The objective is to reset lost root MySQL password on Ubuntu 18.04 Bionic Beaver Linux.
The simplest approach to reset MySQL database root password is to execute mysql_secure_installation program and when prompted entering your new root MySQL password:
$ sudo mysql_secure_installation
This is a companion discussion topic for the original entry at https://linuxconfig.org/how-to-reset-root-mysql-password-on-ubuntu-18-04-bionic-beaver-linux
SOME OF THE BELOW POSTS WERE TRANSFERRED FROM LINUXCONFIG'S DISQUS COMMENTS:
it works for me…
but I wonder how to change password for ‘sysop’@‘localhost’
It seems not work to me. I still has this error message:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
I have repeat your step more than twice and still I cannot login to MySQL
Marlin Forbes - > Muhammad Baiquni
With mysqld running, do this:
It will ask you for a root password and some security questions. Done.
Lubos Rendek MOD -> Marlin Forbes
Well this is a GURU solution ! The article is now updated to include your suggestion. Thank you for your input.
You have no idea how much I appreciate this article!! I have had hell trying to reset the root password until I stumbled upon this. I am thankful for people like you and your willingness and ability to share things like this. THANK YOU VERY MUCH!!!
"SET PASSWORD..." fails: EROR 1524: plugin auth_socket is not loaded
Lubos Rendek Mod -> Pablo Gadino
This seems to be a result of a resent change in mysql mechanism. Article is now updated. thank you
Nice to see both solutions in the same place — but for whatever reason, on my system Lubos solution worked, while Marlin’s solution did not.
Excellent. I was allover the interverse trying to solve my problem of an unprotected Database.
Thanks a lot.
Thank you!! I happy its the first article that actually includes all the proper steps for Ubuntu 18, usually its a lots of researching to get through the full procedure!
A little more work to be able to comment though
Appreciate this. I tried a bunch of the old ways, and none of it was working, really enjoyed the clear, concise instructions here. Thank you.
I’m getting syntax error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(“linuxc”) WHERE User=‘root’’ at line 1
Welcome to our forums.
What is the exact SQL command you execute? From the error message you posted, I would guess you did not close the value of the key “user” with the left single-quote.
I used ALTER to fix it. I actually tried to change password. now it’s done. thanks
Thank you for the detailed and clear explanation.