How to reset root MySQL password on Ubuntu 18.04 Bionic Beaver Linux - LinuxConfig.org

LinuxConfig.org Articles
1
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:
2

Wendy Sukmajaya
it works for me…
but I wonder how to change password for ‘sysop’@‘localhost’

3

Muhammad Baiquni
Hello,

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

4

Marlin Forbes - > Muhammad Baiquni
With mysqld running, do this:

sudo mysql_secure_installation

It will ask you for a root password and some security questions. Done.

5

Lubos Rendek MOD -> Marlin Forbes
Hi Marlin,

Well this is a GURU solution :slight_smile: ! The article is now updated to include your suggestion. Thank you for your input.

6

James Gonzales
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!!!

7

Pablo Gadino

"SET PASSWORD..." fails: EROR 1524: plugin auth_socket is not loaded

8

Lubos Rendek Mod -> Pablo Gadino

This seems to be a result of a resent change in mysql mechanism. Article is now updated. thank you

9

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.

10

Excellent. I was allover the interverse trying to solve my problem of an unprotected Database.

Thanks a lot.

11

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 :stuck_out_tongue:

12

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.

13

I’m getting syntax error :slight_smile:
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

14

Hi Thlin,

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.

15

Thanks sandmann,

I used ALTER to fix it. I actually tried to change password. now it’s done. thanks

16

Thank you for the detailed and clear explanation.
Billal BEGUERADJ