MySQL server reported that no user with this name exists

View post on imgur.com

 

Past week we have provisioned new infrastructure, post cPanel restore mySQL started giving error

mysqli_connect(): (28000/1045): Access denied for user 'username'@'localhost' (using password: YES)

but when I tried to create a new database from mySQL-Databse-wizard it worked, I was able to access PhpMyAdmin this time. To my surprise there were no database except ‘information_schema’ luckily I have backup of all databases.

I SSH’d to the server and found following in error logs

Although the system’s database map includes a MySQL user named “<db user>”, the MySQL server reported that no user with this name exists. Contact your system administrator

from cPanel, I have deleted the user and reCreated him and assigned to the database, this time all went smooth and sqlUser got required permissions on the database

View post on imgur.com

 

 

Leave a comment