Install MySQL compression pack version under Windows 7

Install MySQL compression pack version under Windows 7

Version: 5.6.17 64bit

1. Place the extracted folder in a directory, such as C:\software;

2. Create a new mysql_home=c:\software\mysql-5.6.17-winx64 in the environment variable and add the%mysql_home%\bin to the system variable path;

3. Copy the root directory under My-default.ini, rename it to My.ini, and modify the following sections as the actual situation:

# These is commonly set, remove the # and set as required.
Basedir = c:/software/mysql-5.6.17-winx64
DataDir = C:/software/mysql-5.6.17-winx64/data
Port = 3306

4. Execute mysqld-install to install MySQL to Windows service under command line (Mysqld-remove will uninstall the service);

If an error occurs: Install/remove of the service denied, you should right-click Cmd.exe under C:/windows to run as administrator.

5. Execute the net start MySQL startup service (net stop MySQL will stop the service).

Tips:

The root user of the MySQL that you just installed is no password, you can connect to MySQL and set it with the following statement (password is 123):

mysql> Update Mysql.user set Password=password (' 123 ') where user= ' root ';
mysql> flush Privileges;

If an error occurs: UPDATE command denied to user "@ ' localhost ' for table ' user ' error, go to the Mysql/bin directory and execute

Mysqladmin-uroot Password Password

At logon, under command line:

Mysql-u Root-p Enter the password at the prompt.

Install MySQL compression pack version under Windows 7