Mysql compressed package version installation and configuration methods graphic tutorial, mysql installation and configuration

Mysql compressed package version installation and configuration methods graphic tutorial, mysql installation and configuration

You can install Mysql by Using msi or zip. To decompress the zip package to a directory, you must configure it. Next we will describe the installation method of Mysql compressed package version in detail. If this article is incorrect, I hope you can correct it. Thank you very much.

1. Download the mysql compressed package file

: Http://dev.mysql.com/downloads/mysql/

① Select the mysql version:

② Select the appropriate version based on the computer system, and click Download To Go To The jump page for non-Logon Download (that is, you do not need to register for Logon on the website): 1, as shown in Figure 2

Click"No thanks, just start my download. "Start download

Ii. decompress and install the compressed package

You can install it on any system disk. I am used to installing it on drive D. Therefore, a new mysql folder is created under drive d to store the mysql decompression file (do not tell me how to decompress the file ). Directory structure: D: \ mysql \ mysql-5.6.33-winx64. At this step, many beginners will directly run Directory D: \ mysql \ mysql-5.6.33-winx64 \ binmysql.exe file, and then pop up a box, a flash will disappear, the reason is that the mysql service has not yet been installed. So far, I just downloaded the compressed package and decompressed it to the corresponding directory.

The following describes how to install the mysql service:

1. Configure the my. ini file.

In D: \ mysql \ mysql-5.6.33-winx64 \ (note that this directory should be with your own directory, I download version 5.6 here, if you download version 5.5, this directory is different.) create a configuration file named my. ini, and then copy the following configuration code to my. ini (change the path in the code to your own file storage path ).

Code:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ mysql \ mysql-5.6.33-winx64 # Set the mysql database data storage directory datadir = D: \ mysql \ mysql-5.6.33-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

2. Install the mysql service:

Run C: \ Windows \ system32directory as administrator to find this cmd.exe. Be sure to run it as administrator. Otherwise, the installation will fail. Open the cmd window as an administrator, switch the directory to the bin directory of the decompressed file, and enter mysqld install and press enter to run the command. Note that it is mysqld, not mysql. Simply enter the command in the image in cmd.

Installed successfully:

After the installation is successful, someone directly enters mysql-uroot-p and then press Enter. The system still prompts that the database cannot be connected. Why? This is because after mysql is successfully installed, you must enable the mysql service to use it.

3. Start mysql Service

① Control panel-> Administrative Tools-> services-> mysql-> Start.

Now, you can use the mysql service. After installation, if the error 1066 occurs during the startup process, it is because of my. ini configuration problems. Check whether the path in my. ini has been changed to its own path.

When you enter the mysql-uroot-p command to connect to the database, the system will prompt you to enter the password. The root password is blank by default. Press enter.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.