Saturday, May 5, 2012

MYSQL Authority~!


$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; 

mysql> FLUSH PRIVILEGES;
if i want all ipaddress can access to DB Server
mysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'your-root-password'