0

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

Flimzy
  • 381
Aruna Chamara
  • 1

1 Answers1

1

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

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

  2. Run MySQL like:

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

or

$ mysqld -uroot --skip-grant-tables
Simon Sudler
  • 4,111
jet
  • 7,452