Page 1 of 1

Connect app to remote MySQL DB

Posted: 2018-05-29 19:03
by mysh_eireannach
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

Re: Connect app to remote MySQL DB

Posted: 2018-05-31 13:48
by R Tammam
Hello mysh_eireannach,
i think you will need to make sure that port 3306 on the second server is open

Re: Connect app to remote MySQL DB

Posted: 2018-06-02 19:16
by pbottcher
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.