Steps for using the non-installed version of MySQL and solutions for forgetting the password

The first step is to unzip the compressed package to the corresponding disk.

The second step is to open cmd and enter the bin directory of the unzipped folder, and run mysqld -install.

The third step is to start the service: enter the unzipped folder with cmd and execute net start mysql.

The fourth step is to install the graphical interface navicat.

Solution if you forget your password:

1. The administrator logs in to the system and stops the MySQL service or ends the mysqld process

2. Enter the command line and go to the installation directory of MySQL. Assume that the installation directory is d:\mysql\, CMD enters the command line

3. Run d:\MYSQL\bin\mysqld --skip-grant-tables to start mysql and turn off permission checking

4. Run d:\MYSQL\bin\mysqladmin -u root flush-privileges password "123" to reset the root password

5. d:\MYSQL\bin\mysqladmin -u root -p shutdown

6. Restart the mysql service, net stop mysql and then net start mysql, then mysql -u root -p and enter the password to log in

The verification is successful and MySQL is running normally again.

7. Log in to mysql -u root -p

The above are the steps for using the non-installation version of MySQL and the solution to forgetting the password. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!