host - How to migrate mysql from localhost to IP address -


i running mysql in localhost under port number 3306. want access mysql database remotely. system has ip address , want use instead of localhost. can please tell me how can achieve one.

have written code for accessing remote database. there error?? if need access database remotely need following .

mysql :-

 mysql> grant on *.* root@'localhost' identified 'your-root-password';    mysql> flush privileges; 

this grant users access database remotely.


Comments