Connecting To A Live Website MySQL Database

Please do not offer money for answers in the forum in the future. See also the Forum Guidelines: https://ww.wp.xz.cn/support/guidelines/#do-not-offer-to-pay-for-help

Your question has practically nothing to do with WordPress itself. I would rather recommend that you contact a developer community such as https://stackoverflow.com. However, the following instructions will ensure that a connection to an external server works:

• You need to know under which port the external database server can be reached. For MySQL it is normally 3306, but this can also be changed by the hosting.
• No firewall may block the path to the database port on the external server. If necessary, the firewall must be configured accordingly.
• The external database server itself must be configured to allow external connections. For security reasons, this is rarely the case nowadays.
• The external database server must have a suitable user configuration for incoming requests. For security reasons, this is rarely the case nowadays.
• The server from which you establish the connection must not have a firewall that blocks the database port. This is also a security aspect for outgoing connections.

There are also a few other things to consider. If you have any questions, I would recommend contacting the support of the hoster where the external database server is located.

• This reply was modified 1 year, 4 months ago by threadi.