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

Popular posts from this blog

javascript - Wordpress slider, not displayed 100% width -

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -