New course! Every coder should learn Generative AI!
Try a free lesson+ 4
Similar messages were reported in the following links:
https://www.000webhost.com/forum/t/cannot-connect-to-databse-proxysql-error-access-denied-for-user/61708/6
https://www.reddit.com/r/PHPhelp/comments/5yvpuj/mysql_connect_proxysql_error_access_denied_for/
It looks like you're probably using an incorrect username or password.
If you have a MySQL client tool installed, I would use that to troubleshoot the problem until you're ready to test your code again.
If you have WAMP, MAMPP, or XAMPP installed, you can open a terminal and run something like:
mysql -u root -h localhost -p
or in your case more like:
mysql -u id12583017_holyboi -h yourhost.com -p
After getting the correct credentials, continue your manual test by running something like this:
use yourdatabase
select * from yourtable;
I would manually run a select on a table that your code needs to read. This would verify that your user has permission to read the table. Insufficient permissions can cause your code to fail too.
If you can manually do similar steps to your PHP, you should have the correct credentials for your PHP script.
+ 2
holyboi, you don't have a laptop or desktop? I get that you like using your phone but a lot of software development tasks are easier with a conventional computer.
If you have access to phpmyadmin somewhere, you can test your credentials there too.
+ 2
It sounds like you might be confusing PHPMyAdmin with your PHP script. You never said you had this problem with PHPMyAdmin specifically but tagged your question saying you were using PHP.
If you're manually entering credentials into PHPMyAdmin(not your custom PHP code), then you have a way to quickly check if your credentials work. If your creds fail with PHPMyAdmin, you know your credentials are the problem because PHPMyAdmin is a thoroughly tested and stable application. That gives you much more helpful evidence of the problem than seeing your code fail because your code could have any number of bugs in it.
If you don't know what PHPMyAdmin is, check:
https://en.wikipedia.org/wiki/PhpMyAdmin
It is available along with cPanel in some web hosting websites.
If you know credentials are your problem, fix it with your hosting service. There should be a way to manage SQL users or "database users" in your website hosting service's control panel. How exactly you do that depends on your hosting service. Here is how to do that with GoDaddy:
https://ca.godaddy.com/fr/help/creer-une-base-de-donnees-mysql-ou-ms-sql-16017?lang=en
+ 1
Do you use facebook, Skype, or gmail chat/Google Hangouts? If you give me a way to instant message and possibly video chat, we can troubleshoot this more.
+ 1
I added emeriebow78@gmail.com to gmail/Google Hangouts so you should receive an invitation.