Here is the third and the final part of the article about configuring Magento MySQL for remote access from a different host.
Verifying the DB access – Magento MySQL
First to verify the connection, enter the following codes in your web node host.
mysql -u <local database user name> -h <database server ip address> -p
The DB is ready for Mage soft if the MySQL pops up with the following massage.
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 owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Now enter the command on each web server host if the web server is clustered.
Install the Mage software – Magento MySQL
After you install the Mage software. Now we have to specify the following for completing the setup.
First Base URL (Also known as store address) to specify the web node IP address or host name
Secondly remote database server IP address is the DB host (If the DB is clustered it is the load balancer)
Now, use web node DB username as DB username (the username has root access).
Then use the web node remote server DB password as DB pass.
Finally use the web node remote server DB name as DB name.
Hence we tried our best to describe the configurations of Magento MySQL to access remotely from a different host. But the process also needs expert skills to run successfully. However, our Hosting is serving Magento hosting plans with all technical support and web development support provided free. Aspiration Hosting plans start out at $9.99/mo.
Tanzia Farin Chy for Aspiration Hosting.