Hi All,
I have question. Need connect app located on first web server, to MySQL DB on second.
What I need to use at config.php $dbServer = 'localhost' instead localhost?
I add second server IP Address to Remote MySQL. But if I replace 'localhost' with 'Second server IP', no connection.
In addition, checked 'Second server IP:3306' same, no connection.
Any tips for my problem?
Thanks
Connect app to remote MySQL DB
-
- Veteran Member
- Posts: 35
- Joined: 2016-02-16 22:31
Re: Connect app to remote MySQL DB
Hello mysh_eireannach,
i think you will need to make sure that port 3306 on the second server is open
i think you will need to make sure that port 3306 on the second server is open
Re: Connect app to remote MySQL DB
Also verify that your user is allowed to connect. An verify what kind of mysql installation you are running. If it is a secured installation you need special settings.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.