RSS

Mysql Remote Access Permission to other system in your network (Ubuntu)

13 Aug

Step 1:

sudo gedit /etc/mysql/my.cnf

Comment Line Number 52 using #, Its like

Example:

#bind-address = 127.0.0.1

Step 2:

sudo service mysql restart

If it is not restarted, Please use start and stop command.

sudo service mysql stop

sudo service mysql start

Step 3: 

Run the Below mentioned query in the mysql to grant access.

GRANT ALL ON *.* TO root@’%’ IDENTIFIED BY ‘root’;

Step 4:

Access mysql in other system using your system IP .

Please use below mentioned command to find the mysql port no.

ps -ax|grep mysql

 
Leave a comment

Posted by on August 13, 2011 in MySQL, Ubuntu

 

Tags: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: