Wednesday 27 July 2016

how to grant remote access to mysql server ?

Hi All,

To grant remote access of mysql server please use these command

 
 
#) GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
 
#) FLUSH PRIVILEGES
 
 
I am using centos 6.7 64 bit OS