Detailed description of the Installation Method of Mysql compressed package version, mysql Installation Method

Detailed description of the Installation Method of Mysql compressed package version, mysql Installation Method

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.

Mysql-5.6.33-winx64
# Set the directory for storing mysql database data
Datadir = D: \ mysql \ mysql-5.6.33-winx64 \ data
# Maximum number of connections allowed
Max_connections = 200
# The default character set used by the server is the 8-bit latin1 character set.
Character-set-server = utf8
# The default storage engine used to create a new table
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 the 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.