I’m having issues getting my PHP website connected to a MySQL database. I followed the instructions online, have my website setup with an SFTP connection pointed to the correct folder. The website connection is successful when I do “Check” at the bottom.
I’m able to connect to the MySQL database from my webserver using a MySQL client and the same username/password. So it’s not a port problem or a user permissions problem.
The first time I enter the settings and hit test connections, I get this error:
If I don’t close the window and hit “Test Connection” again, I get this error:
It’s odd, because if I test the connection the website, it works fine. If I update the website html/php files, everything updates.
I’m at a loss at this point. Any help or guidance is appreciated.