Hi all! I have trouble connecting to my SQL server, I have added “%” as an access host and using my user has all privileges granted in cPanel, yet the connection fails when I press “Test Connection.”
I am completely new to server-side/back end stuff, and searching around hasn’t helped in this scenario. I hope someone here could help a noob out. Thanks!
Are you first able to verify the credentials are correct by logging into MySQL from your local machine? (Assuming the MySQL server is remote).
I’d start there as you’ll get better error messages that way and can hopefully figure out the problem.
Hi, Jonh. Can you indicate an host fully tested? I have the same problem in my vps.
I’ve tested with freemysqlhosting.net which works but any MySQL database host that has a publically accessible interface and doesn’t require IP whitelisting should work with the MySQL service.