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

This article is about MySQL download installation sample analysis. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

1. MySQL database download can visit the official website: www.mysql.com/

2. Click MySQL Community Server under Community module under DOWNLOADS module to download.

Since the latest version is MySQL Community Server 5.7.21, it is recommended that bloggers download historical versions. The download of this blog is 5.6.39 Download steps:

Enter and select MySQL version and host

Select the corresponding number of bits to download according to your computer, this machine is 64 bits, click download.

Go to the next page, this page needs to register MySQL account, or you can download it directly without registration.

Click No thanks, just start my download.

3. Configure MySQL database as follows:

MySQL installation files are divided into two types, one is msi format, one is zip format. Zip format is their own decompression, decompression after MySQL can actually be used, but to configure.

If the user is not configured to use MySQL directly, the error shown in the diagram will appear. This is because no environment variables are configured. Configuring environment variables is simple:

My Computer-> Properties-> Advanced-> Environment Variables

Select PATH and add: Path to your mysql bin folder: D:\Program Files\JavaTool\MySQL\mysql-5.6.39-winx64\bin

After configuring the environment variables, you 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 D:\Program Files\JavaTool\MySQL\mysql-5.6.39-winx64my-default.ini, or create your own my.ini file.

Modify or add configuration in:

basedir=D:\Program Files\JavaTool\MySQL\mysql-5.6.39-winx64 (mysql directory)

datadir=D:\Program Files\JavaTool\MySQL\mysql-5.6.39-winx64\data (mysql directory\data)

Note: The code of my.ini file must be English code (such as ANSI in windows), not UTF-8 or GBK.

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

Enter the command cd D:\Program Files\JavaTool\MySQL\mysql-5.6.39-winx64\bin to enter the bin folder of mysql (regardless of whether the environment variables have been configured, enter the 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

To start the service, enter the command:net start mysql. Start successfully as shown.

After the service starts successfully, enter the command: mysql -u root -p (the first login does not have a password, press Enter directly)!

Enter directly, as shown in the figure, login successfully.

Error Summary:

If an error occurs when starting the service, please see Note:

Error 2 and Error 1067 occur frequently.

If "Error 2: The system cannot find the file," check whether you have modified the configuration file or entered the bin directory. If the configuration file has been modified correctly and entered the bin folder, you need to delete mysql (enter mysqld -remove) and then reinstall (enter mysqld -install). If Error 1067 appears, it is a configuration file modification error. Verify whether the configuration file is correct.

Thank you for reading! About "MySQL download installation example analysis" This article is shared here, I hope the above content can have some help for everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

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.