{"id":740,"date":"2012-08-20T01:06:07","date_gmt":"2012-08-20T07:06:07","guid":{"rendered":"http:\/\/blog.supportpro.com\/?p=740"},"modified":"2025-04-28T05:18:52","modified_gmt":"2025-04-28T11:18:52","slug":"setting-up-mysql-remote-server","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/setting-up-mysql-remote-server\/","title":{"rendered":"Setting up MySQL remote Server"},"content":{"rendered":"

Remote server<\/a> configuration<\/strong><\/p>\n

1. Edit the \/etc\/my.cnf file in the remote server and add the following line somewhere under [mysqld] in the my.cnf file
\nbind-address=<IP address of the remote server>
\n2. Restart mysql on the server<\/p>\n

Granting privileges for database::<\/strong><\/p>\n

In order to access a database ‘abc’ on the remote server from another machine, we need to add sufficient privileges for a user in the machine from which the connection is made. i.e. from the mysql prompt ( use mysql command or mysql -u root -p to enter the prompt).<\/p>\n

mysql> grant all privileges on abc.* to username@IP address of the machine from which the connection is to be made identified by <password><\/p>\n

Example::<\/p>\n

Let us consider two machines with the following data
\nRemote server IP:: xxx.xxx.x.1
\nIp of local machine from which connections to remote database in xxx.xxx.x.1 are made:: xxx.xxx.x.100<\/p>\n

Edit the my.cnf file in the remote server and add the following<\/p>\n

bind-address = xxx.xxx.x.1
\nanywhere under [mysqld]<\/p><\/blockquote>\n

Inorder to grant permissions for the user ‘bl’ from xxx.xxx.x.100 to connect to the database ‘ab’ in xxx.xxx.x.1 , enter the mysql prompt and type in the command<\/p>\n

mysql>grant all privileges for ab.* to bl@ xxx.xxx.x.100 identified by pass; (# where pass is the password)
\nmysql>flush privileges;
\nmysql>exit<\/p><\/blockquote>\n

Checking for mysql connectivity from xxx.xxx.x.100 to xxx.xxx.x.1<\/p>\n

Enter the command below in the machine xxx.xxx.x.100 and type in the password pass upon the prompt
\n[root@local ~]# mysql -u bl -h xxx.xxx.x.1 -p<\/p>\n

Inorder to specify the remote database name and location for a site software like wordpress, joomla etc. , modify the configuration file and update the details of the database along with the password and IP address of the remote server in the specified filed.<\/p>\n

Inorder to configure wordpress to access the database ‘ab’ from a remote machine xxx.xxx.x.1, modify the configuation file as below<\/p>\n

define(‘DB_NAME’, ‘ab’);
\ndefine(‘DB_USER’, ‘bl’);
\ndefine(‘DB_PASSWORD’, ‘pass’);
\ndefine(‘DB_HOST’, ‘ xxx.xxx.x.1’);<\/p><\/blockquote>\n

If you require help, contact SupportPRO Server Admin<\/a><\/p>\n

\"Server<\/a><\/span>