Steps for using a non-installed Mysql version and solutions for forgetting the password, mysql forgot the password

Steps for using a non-installed Mysql version and solutions for forgetting the password, mysql forgot the password

Step 1 extract the compressed package to the corresponding disk.

Step 2 open cmd to enter the bin directory of the decompressed folder and run mysqld-install.

Step 3: enable the Service: Run cmd to enter the decompressed folder and run net start mysql.

Step 4 install the image interface navicat.

Solution for forgetting the password:

1. log on to the system as an administrator, stop the MySQL service, or end the mysqld process.

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

3. Run d: \ MYSQL \ bin \ mysqld -- skip-grant-tables to start mysql and disable permission check.

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 mysql, net stop mysql, net start mysql, and mysql-u root-p to log on.

The verification is successful and mysql runs normally again.

7. log on to mysql-u root-p

The above section describes how to use the non-installed Mysql version and how to forget the password. I hope it will help you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!