Thursday, August 19, 2010

MySQL set privileges to remote pc

grant all privileges on *.* to root@10.10.1.52 identified by 'your_password';


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

How to install mysql-admin

yum install mysql-admin*