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
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
Return to the Artful MySQL Tips page