Sql | SoloLearn: Learn to code for FREE!

+4

Sql

I tried to connect my php to my database but it wrote ERROR: Could not connect. ProxySQL Error: Access denied for user '[email protected]:4780:bad:c0de::13'@'2a02:4780:bad:f00d::10' (using password: YES). What will I do

2/11/2021 2:53:03 PM

🔥💥holyboi💥🔥

10 Answers

New Answer

+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

Josh Greig sir but I used Android device XAMPP don't work in my phone

+1

Josh Greig sir but they write access denial when I want to access phpmyadmin, guess that's the reason why it couldn't connect

+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

OK. [email protected] Josh Greig thanks for your concern

+1

I added [email protected] to gmail/Google Hangouts so you should receive an invitation.

+1

Josh Greig thanks sir, You did it

0

Josh Greig , if I run the code to connect my php to my database I got this ERROR: Could not connect. php_network_getaddresses: getaddrinfo failed: Name or service not known And it always write server down,if I want to login directly it will say Access denial