Uninstalling and reinstall MySQL for LAMP server (forgot password)

Question

I have forgotten username and password for MySQL in LAMP stack on Ubuntu. I want to uninstall and reinstall MySQL for the LAMP server.

Does this answer your question? How to recover mysql password? — pLumo, Apr 17 '20 at 08:50
or maybe better this: https://askubuntu.com/questions/118772/how-to-change-root-password-for-mysql-and-phpmyadmin — pLumo, Apr 17 '20 at 08:51

score 1 · Answer 1 · edited Apr 17 '20 at 12:45

1

Create a file (i.e. mysql-reset) containing this line:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

Run MySQL like:

$ mysqld_safe --init-file=/path/to/mysql-reset &

or

$ mysqld -uroot --skip-grant-tables

edited Apr 17 '20 at 12:45

Simon Sudler

answered Apr 17 '20 at 10:41

jet

1 Answers1