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 = 192.168.1.116


2. Create one database and give privilege.

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


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

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


4. Verify whether remote mysql server is working.

mysql -u bob -h 192.168.1.116 -p password:


that's all..

No comments:

Post a comment

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