SQLSTATE[HY000] [1045] ProxySQL Error: Access denied for user


#1

“Error!: SQLSTATE[HY000] [1045] ProxySQL Error: Access denied for user ‘id123456_abcdefghijklmno’@‘2a02:4780:bad:f00d::2’ (using password: YES)”

I change password… nothing
my account is flyescola I can put more information by PM…

gedflyescola.000webhostapp.com


#2

What is your website?


#3

gedflyescola.000webhostapp.com


#4

Has your script ever worked?

Try visiting general settings in the control panel and then change PHP version to something that works like 5.4


#5

Make sure that you have used correct…Details to connect to your database.

(“hostname”,“username”,“password”,“database name”)

Hostname: localhost


#6

Hi … I also end up with the error message … Appreciate the help to fix this issue

=======================
usermanagement.000webhostapp.com
DB Name DB User DB Host
id563317_bangalore id563317_bangaloretester localhost

I’ able to see the table details in phpMyAdmin

My connection code : dbconnect.php

$con = mysqli_connect(“localhost”," id563317_bangaloretester “,“Bangalore”,” id563317_bangalore ");
if(!$con)
{
echo “not connected to db recheck the details”;
}
else
echo “Connected to database successfully”;

THE ERROR IS AS FOLLOWS
: Warning: mysqli_connect(): (HY000/1045): ProxySQL Error: Access denied for user ‘id563317_bangaloretester’@‘2a02:4780:bad:f00d::2’ (using password: YES) in /storage/h2/317/563317/public_html/includes/dbconnect.php on line 3
not connected to db recheck the details

======================
Thanks…


#7

Try 127.0.0.1 as your host then if still error back to localhost

Make sure your database name, username and password all match exactly, if no resolution try changing php version within your 000webhost control panel down to like 5.5


#8

If I use 127.0.0.1
then I will end up with this error !!

Warning: mysqli_connect(): (HY000/2002): Connection refused in /storage/h2/317/563317/public_html/includes/dbconnectTest.php on line 3
not connected to db recheck the details

Thanks


#9

Okay so localhost for sure just make sure you are using correct username, database name and password - feel free to change the password under manage database in the control panel.


#10

Thanks for the quick responses …

Created a new DB… not changed the PHP version … it is 7.1 …

Now finally able to Connect to DB with this code

$con = mysqli_connect(“Localhost”,“id563317_newuser”,“db@2017”,“id563317_newdb”);

Regards,

Jagadish


#13

Is your issue solved??


#14

Think so.
OP open a new thread if you encounter more issues.


#15