Sololearn: Learn to Code
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.
11th Feb 2021, 5:50 PM
Josh Greig
Josh Greig - avatar
+ 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.
11th Feb 2021, 9:16 PM
Josh Greig
Josh Greig - avatar
+ 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
11th Feb 2021, 9:57 PM
Josh Greig
Josh Greig - avatar
+ 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.
12th Feb 2021, 2:25 AM
Josh Greig
Josh Greig - avatar
+ 1
I added emeriebow78@gmail.com to gmail/Google Hangouts so you should receive an invitation.
12th Feb 2021, 1:55 PM
Josh Greig
Josh Greig - avatar