Windows environment MySQL decompression version configuration

1. Download and unzip

Download mysql-5.5.10-win32.zip to your website and extract MySQL to any path, such as C: \mysql-5.5.10-win32

2. Setting Environment variables

Open computer, properties, advanced system settings, environment variables, create a new environment variable named:mysql_home, variable value for your mysql root directory, e.g. C: \ MySQL-5.5.10-win32
Then add the following in the system variable Path :; %MYSQL_home%\bin

3. Install MySQL Service

To open a command prompt as an administrator, execute the command:mysqld-install Install the MySQL service to Windows services

Note: If you want to uninstall the MySQL service, do:mysqld-remove

4. Start the MySQL service

Execute:net start mysql

Note: If you want to stop the MySQL service, do the following:net stop MySQL

5. Set the password

Input mysql-uroot into MySQL (default root password is empty)

Perform

mysql> use MySQL;
mysql> Update user Set Password=password ("New_pass") where user= "root";
mysql> flush Privileges;
Mysql> exit;

6. Login

Enter mysql-uroot-p carriage return

Enter password

Note:

Forgot password

Join in the My.ini

[Mysqld]
#跳过密码验证
#skip-name-resolve

Then enter mysql-uroot directly into the CMD and perform the steps in 1

Windows environment MySQL decompression version configuration