Access Denied - MySQL

[GoPantheoN]

Didnt use new user/name. Does FLUSH PRIVILEGES wont return any result ?

[soft2050]

Didnt use new user/name. Does FLUSH PRIVILEGES wont return any result ?

Try to use new username and password

I guess Flush privileges returns some result like "Query Ok, 0 rows affected <
xxx seconds>"

[GoPantheoN]

Thats the problem. Flush Privileges doesnt return any value

[soft2050]

Thats the problem. Flush Privileges doesnt return any value

• Have you tried adding new username and password? If yes, what was the result? Any error in query
• Try to quit the session by using quit command
• Restart the mysql server usually "service mysqld restart"
• Try to reconnect to the mysql, and execute like this "flush privileges;" (in small letters)

[GoPantheoN]

I added the user name and pass in phpmyadmin. I ll do the rest and tell you the results.

[GoPantheoN]

Service restarted, tried flush privileges in small letter too, no return of any result.

mysql> show grants for 'warezxl_wxl'@'localhost';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for warezxl_wxl@localhost                                                                                     |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'warezxl_wxl'@'localhost' IDENTIFIED BY PASSWORD '79**4*****bc' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `warezxl_wxldb`.* TO 'warezxl_wxl'@'localhost' WITH GRANT OPTION                             |
+----------------------------------------------------------------------------------------------------------------------+

Permission is available.

Can I try flush tables ?

[GoPantheoN]

Problem was not fixed. Restored the vps backup.