Webinoly is just the perfect tool for NGINX experts. Give it a try!
0 votes
559 views
by Rookie

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'?

2 Answers

0 votes
by Rookie

Hi. I have this issue too. Please help!

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

by Expert

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.
0 votes
by Rookie
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
by Expert
Be sure you have the latest Webinoly version installed (1.17.2). I'm sure this issue should be resolved following the steps I explained in my previous comment. Also, it's impossible to help you if you don't provide details!
by Rookie

Hi. Thanks for reply. I already updated the webinoly. Then the 3 commands again. Then I tried to create WP website. Seems still got errors on MySQL Connection.

by Rookie

This is image for the updated of webinoly

.

by Expert
What's the output of the verify command?
by Rookie

Thanks for reply. Here is the screen shot

by Expert

Try running manually some mysql commands to see if passwords are correct. Try these three examples:

  • sudo mysql --user=admin -e "quit"
  • sudo mysql --user=admin -p12341234 -e "quit"
  • sudo mysql --user=root -p12341234 -e "quit"
Use the passwords you get with: sudo webinoly -dbpass
Did you got an error?
by Rookie

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?
by Rookie

Cannot login using paswd given on command sudo webinoly -dbpass

by Expert
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?
by Rookie
The last one is correct Mr. I can give you access to my server if you want. Thanks
by Expert
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.
Welcome to the Community site for Webinoly.

Our Optimized LEMP Web Server is a powerful set of commands for doing just about anything you could wish.

With Webinoly you can set up your NGINX web server in just one step.

* * * * * * *

To report a bug, please create a new issue on GitHub or ask a question here with the bug tag.
Webinoly Support Paypal Donations

PayPal · GitHub Sponsors · Bitcoin

It is very important that any visitor to the site read the disclaimer, terms of use and privacy and legal statement before start browsing.

...