Create the remote connection
To create a remote connection:
On your database server, as a user with
root privileges, open your MySQL configuration file.
To locate it, enter the following command:
The location displays similar to the following:
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
Search the configuration file for
If it exists, change the value as follows.
If it doesn’t exist, add it anywhere except the
bind-address = 192.168.19.33
Save your changes to the configuration file and exit the text editor.
Restart the MySQL service:
service mysql restart
Grant access to a database user
To enable your web node to connect to the database server, you must grant a web node database user access to the database on the remote server.
This example grants the
root database user full access to the database on the remote host.
To grant access to a database user:
- Log in to the database server.
- Connect to the MySQL database as the
Enter the following command:
GRANT ALL ON website.* TO firstname.lastname@example.org IDENTIFIED BY 'password';
Verify database access
On your web node host, enter the following command to verify the connection works:
mysql -u username -h 192.168.19.41 -p
If the MySQL monitor displays as follows, the database is ready for use by the website:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 213
Server version: 5.6.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.