Access MySQL DB Remotely

Posted in by at 05:06 Comments Off on Access MySQL DB Remotely

Access MySQL DB Remotely

Tudip Technologies

24 June, 2016

You have a machine where your MySQL is running and you want 2 developers to access a Database remotely.
You can follow the steps below to set up the access permissions for those 2 developer machines.

Steps for access remote DB

First Server/Remote machine should give permission to client
Then developer machines would be able to access remote db using DB’s server ip and port number where the MySQL is running


Steps to give permissions to developer machine using command prompt
Go to mysql on DB machine> In case mysql is not in the path, you would have to go to mysql/bin directory

mysql>use mysql 
mysql>GRANT ALL ON *.* to root@193.164.1.11 IDENTIFIED BY 'abc'; // Here the root is the MySQL username of the DB, abc is the password for this root account and 193.164.1.11 is the developer machine IP address
 

Steps to give permission to developer machine using phpmyadmin

1.Go to phpmyadmin
Ex: http://localhost/phpmyadmin/
2.Select privileges
3.Click on Add a new User link
4. Then proceed