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
Post a Comment