![]() ![]() ![]() ![]() Off course do not forget to change MyNewPasswith your actual password. Save it to a safe directory where no other user can open it because it contains your next MySQL root password. We need to create a text file that contains the following line. Create a text containing password-assignment on a single line Stop the MySQL Server sudo systemctl stop mysql For Windows system, you can follow this explanation. The following trick works on Linux system only. In case you forgotten your MySQL root password, follow these steps below to reset your MySQL root password. Output sudo mysqladmin -u root -p shutdown Enter password: + Done sudo mysqld_safe -skip-grant-table You will be asked to enter root password. Now continue with this command flush privileges You should see the following output on your screen: MariaDB > update er set password=password('12345') where user="root" Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 UPDATE er SET Password=PASSWORD('your-new-password') WHERE User='root' You won’t be asked to enter root password. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |