[tutorial] Installing MySQL 9.2.0 with Laragon & Changing the Password

[rfrkk]

Here’s the translated and simplified version of your notes on Installing MySQL 9.2.0 with Laragon & Changing the Password:

---

Installing MySQL 9.2.0 with Laragon & Changing the Password

Steps

1. Download MySQL

   • Go to the MySQL official website and download the portable ZIP package.
   • Extract the downloaded ZIP file to the laragon\bin\mysql directory.

2. Modify the Configuration File

   • Open the my.ini file and comment out the following line:

     default_authentication_plugin=mysql_native_password
     datadir="YOUR PATH\laragon\data\mysql-9

   • Set the my.ini file to read-only to prevent accidental changes.

3. Start MySQL

   • Open Laragon and click the Start All button. Wait for MySQL to initialize completely.
   • Then click the Stop button to stop the MySQL service.

4. Open Command Prompt

   • Press Win + R, type cmd, and press Enter.

5. Start MySQL in No Password Mode

   • In the command prompt, enter the following command:

     mysqld --skip-grant-tables --shared-memory

6. Open Another Command Prompt

   • Press Win + R again, type cmd, and press Enter.

7. Log into MySQL

   • In the new command prompt window, enter:

     mysql -u root

8. Flush Privileges

   • Enter the following command to refresh privileges:

     FLUSH PRIVILEGES;

9. Change the Root Password

   • Enter the following command to change the root user's password:

     ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

   • Replace new_password with the password you want to set.

10. Restart MySQL

    • Open Laragon and click the Start All button to test if MySQL is running properly.

---

Notes

1. If the installation fails, go to the laragon\data directory and delete the mysql-9 folder.
2. Make sure the my.ini file has been modified as described above.

---

[Cyb3r9]

Insead of Download Manually you can add from Quick Add

[rescenic]

Step 2: mysqld --initialize --user=mysql --datadir="C:\Users\user\laragon\data\mysql-9"
Make sure mysql-9.2.0-winx64\bin folder in user path.

[Ringoinmel]

It doesn't work with version 6. In step 3, the screen shows 'Initializing' and not moving anymore. Can anyone help? Thanks.

[rfrkk]

Please confirm first:

1. Stop wamp
2. Download https://dev.mysql.com/downloads/mysql/5.5.html?os=3&version=5
3. Enter laragon6\data, find the folders related to mysql-9, etc. and delete them all.
4. Repeat from step 2