Access MySQL on another workstation

from the Artful MySQL Tips List

It's often not a good idea to run an executable on boxA from boxB, especially when the boxA program depends on configuration settings which reference boxA paths. Also, it's not usually a good idea to share system folders, for example %windir% and %programfiles% on Windows. So to access an existing MySQL server instance on boxA from boxB, install MySQL on boxB for the sole purpose of using that mysql client executable to talk to the MySQL installation on boxA. Then on boxB you can access MySQL on boxA with ...
mysql -hboxA -uUSR -pPWD
where USR and PWD are appropriate username and password values for the instance of MySQL on boxA. For more detail on this for Windows networks, see Connection issues on networks with Windows.

Last updated 6 Jun 2012

Return to the Artful MySQL Tips page