Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install MySQL 5.6 for Windows configuration decompression version, Xiaobian feel quite practical, so share to everyone as a reference, I hope you can have some harvest after reading this article.

MySQL is a small but powerful database that is currently very popular. However, the official website provides installation packages in two formats, one in msi format and the other in zip format. Many people unzip the zip format and find that there is no setup.exe, facing a pile of files confused, do not know how to install.

Tools/raw materials

Win 7 operating system

MySQLzip format installation package

method/step

1、

MySQL installation files are divided into two types, one is msi format, one is zip format. If it is msi format, you can click install directly and install it according to the installation tips it gives (I believe everyone can understand English tips). Generally MySQL will be installed in C:\Program Files\MySQL\MySQL Server 5.6. The zip format is decompressed by itself. After decompression, MySQL can be used, but it needs to be configured.

2、

After decompression, you can rename the folder and put it in the appropriate location. Personally, it is recommended to rename the folder MySQL Server 5.6 and put it in the C:\Program Files\MySQL path. And you can put it anywhere you want.

3、

After completing the above steps, many users start using MySQL, but the errors shown in the diagram appear. This is because no environment variables are configured. Configuring environment variables is simple:

My Computer-> Properties-> Advanced-> Environment Variables (cmd-->sysdm.cpl)

Select PATH and add the path to your mysql bin folder (e.g. C:\Program Files\MySQL\MySQL Server 5.6\bin ).

PATH=.......; C:\Program Files\MySQL\MySQL Server 5.6\bin

4、

Don't start mysql after configuring the environment variables. We also need to modify the configuration file (if there is no configuration, the error in the figure will appear when starting later!: Error 2 The system cannot find the file), mysql-5.6.1X The default configuration file is in C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini, or create a my.ini file yourself,

Modify or add configuration in it (as shown in the figure):

[mysqld]

basedir=C:\Program Files\MySQL\MySQL Server 5.6

datadir=C:\Program Files\MySQL\MySQL Server 5.6\data (mysql directory\data)

5、

Run cmd as an administrator (be sure to run it as an administrator, otherwise you don't have enough permissions),

Enter cd C:\Program Files\MySQL\MySQL Server 5.6\bin into bin folder of mysql (regardless of whether environment variables have been configured, you must also enter bin folder, otherwise the service will still report error 2 after starting)

Enter mysqld -install(if you run without administrator, you will get the error Install/Remove of the Service Denied!)

installation is successful

Remove service command: mysql -remove

6、

After successful installation, start the service, continue to enter:net start mysql in cmd (as shown in the figure), the service starts successfully!

Many people make mistakes at this time, please note:

Note: Error 2 and Error 1067 often occur at this time.

If "Error 2: The system cannot find the file," check whether the configuration file has been modified or whether the operation is under the bin directory. If the configuration file has been modified correctly and the bin folder has been entered, you need to delete mysql (enter mysqld -remove) and reinstall it (enter mysqld -install);

If error 1067 appears, it is a configuration file modification error. Verify that the configuration file is correct.

7、

After the service starts successfully, you can log in, as shown in the figure, enter mysql -u root -p (there is no password for the first login, press Enter directly), login successful!

8. Change the root password

update mysql.user set password=password('1234') where user='root';

flush privileges;

About "MySQL 5.6 for Windows how to install configuration decompression version" This article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it to let more people see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.