Monday, May 6, 2024
 Popular · Latest · Hot · Upcoming
44
rated 0 times [  44] [ 0]  / answers: 1 / hits: 229150  / 1 Year ago, fri, january 20, 2023, 4:17:14

I recently installed LAMP on Ubuntu 13.04(32-bit) but forgot my phpMyAdmin password. How can I reset its password without re-installing it?


More From » lamp

 Answers
6

Simply change or reset your MySQL root password by doing the following:




  1. Stop the MySQL server



    sudo service mysql stop

  2. Start mysqld



    sudo mysqld --skip-grant-tables &

  3. Login to MySQL as root



    mysql -u root mysql

  4. Change MYSECRET with your new root password



    UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;

  5. Kill mysqld



    sudo pkill mysqld

  6. Start mysql



    sudo service mysql start

  7. Login to phpmyadmin as root with your new password



[#30270] Saturday, January 21, 2023, 1 Year  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
assionortly

Total Points: 423
Total Questions: 121
Total Answers: 115

Location: Chad
Member since Wed, Sep 30, 2020
4 Years ago
;