Phpmyadmin password (How to reset MySQL root's password)

  • | 73 points

    Hi, i need help. I have forgotten my password for phpmyadmin, and i don't know how to reset it. I've googled but solutions are only for wamp, xampp or mysql server that is on his own, and i can't do those things on laragon. Please help:)

  • administrators
    | 132054 points

    MySQL is a service of Laragon, in case you forget your password, you can force change root password using command line (Terminal)

    1. Ensure MySQL is NOT running (Click Stop button if MySQL is running)
    1. Open Terminal, then type:
     mysqld --skip-grant-tables

    MySQL should be running.
    λ mysqld --skip-grant-tables
    2016-02-16 20:58:45 2024 [Note] mysqld (mysqld 10.1.9-MariaDB-log) starting as process 6744 ...

    1. Press Ctrl + T to open New Tab on Terminal and type:
    mysql -u root
    1. When you log in, type: (For MariaDB):
    UPDATE mysql.user SET password=password("YOUR-PASSWORD") WHERE user='root';
    flush privileges;

    4.1 For MySQL 5.7:

    UPDATE mysql.user 
        SET authentication_string = PASSWORD('YOUR-PASSWORD'), password_expired = 'N'
        WHERE User = 'root' AND Host = 'localhost';
    flush privileges;
    1. Hard close mysqld
    taskkill /f /im mysqld.exe 

    Sart Laragon.
    You now can login with user root and password: YOUR-PASSWORD

  • | 73 points

    @leokhoa thank you very much, this is very helpful!!! :D

  • | 36 points


    I got error
    ERROR 1524 (HY000): Plugin '*AFE96312C5DAC26F4D2F2D36435B53DC9B2CD5C3' is not loaded

    when trying to log in with password

  • administrators
    | 132054 points

  • | 174 points

    When I try to do this in DataGrip it does not connect.

    I left the password blank and followed the steps above.

    Any idea what is wrong?

  • administrators
    | 132054 points

    @Some-T : You can reset root password easily using Laragon's Menu (Menu > MySQL > Reset and generate a random password for root)


  • | 174 points

    that sorted it, thanks.

  • | 292 points

    I think you need to remove that original advise it's bust my install. I can no longer create new sites as it says my root pass word is set to NO, and all of my wordpress installs say Error establishing a database connection

  • | 657 points

    Just in case someone comes across this looking for an answer (like I did), what I did is what @leokhoa suggested.

    First I stopped all processes, and selected "Change root password".
    I couldn't have it as blank, but what I did do is re-set it to the password I was using (for instance, "root").

    When I created a Quick App, I no longer got the error that @Gibsonion had.

Log in to reply

Looks like your connection to Laragon was lost, please wait while we try to reconnect.