Friday 10 August 2012

"How to Configure remote mysql server"

"How to Configure remote mysql server"

How to Configure remote mysql server.

Here is the steps :

1.# vi /etc/my.cnf

add: port = 3306 bind-address =

2. Create one database and give privilege.

mysql> CREATE DATABASE remote; mysql> grant all on remote.* to host@'' identified by 'password';

3. Update hotname with the mysql user "bob".(for example)

Update user set Host='' where user='bob';

4. Verify whether remote mysql server is working.

mysql -u bob -h -p password:

that's all..

No comments:

Post a Comment

Note: only a member of this blog may post a comment.