Wednesday 11 August 2010

How to make database IP live using ubuntu?

$ vi /etc/mysql/my.cnf

search bind_address..
comment bind_address..

$ sudo -s -H

$ ls -l /etc | grep my

$ ls -l /etc/mysql | grep my

$ /etc/init.d/mysql restart

$ mysql -u root -p

mysql > show grants;

Now you will see the following query:
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION
Copy above query and paste it into terminal and replace 'localhost' by %.

mysql > flush privileges;

Cheers!