Access denied for user 'admin'@'localhost'

Question

By mistake I deleted the user 'admin' from the MySQL. I created a new one with the same permissions and password but it doesn't work.

Every time I use the command '-wp' to create a new Wordpress returns the following error:

ERROR 1044 (42000) at line 3: Access denied for user 'admin'@'localhost' to database 'test_com'

[Error]: Database configuration failed.

How can I reset the user 'admin'?

Answer 1

Hi. I have this issue too. Please help!

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Comments

Hey Wan Mohd,

• Run the "verify" command sudo webinoly -verify
• Check if sudo webinoly -dbpass can recover the password.
• Run sudo webinoly -server-reset=mysql it will try to reset the admin user.

Answer 2

Hi, thanks for reply. I have got ru the commands and got the recovers passwd. But, I am naive. Still got error on DB connection when to create WP website

Pls help

Comments

No error using these commands

• sudo mysql --user=admin -e "quit"
• sudo mysql --user=admin -p12341234 -e "quit"
• sudo mysql --user=root -p12341234 -e "quit"

I can log to mysql. Then, what should I do?

---

Cannot login using paswd given on command sudo webinoly -dbpass

---

Don't understand, in your first comment you said that you can log in with no problems. Then, in the second comment you said you got an error and the password is invalid.

So, which is correct?

---

The last one is correct Mr. I can give you access to my server if you want. Thanks

---

What password did you use when you said you got no errors running the 3  example commands in my previous comment?

Is the same as the password you recovered with the dbpass command? So, you know the right password?

I can do it in your server if you want, but is a paid service, if you are interested send me an email with the details.