Shulou(Shulou.com)06/01 Report--

How to install MySQL compressed version? This problem may be our daily study or work often see. I hope you learned something from this question. The following is the reference content brought to you by Xiaobian. Let's take a look together!

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.

Steps to install Mysql compressed version:

I. Download mysql zip file.

Download address: dev.mysql.com/downloads/mysql/

① Select the corresponding mysql version: as shown in the figure

② Select the corresponding version according to the computer system, click Download to enter the jump page to download without login (i.e. no need to register on the website): as shown in Figure 1 and Figure 2

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

Second, the compressed package decompression installation.

Zip format installation package needs to be decompressed by itself, after decompression MySQL can actually be used, but to configure.

After decompression, you need to put the folder in the appropriate location, you can put it anywhere you want. For example, put the folder in D:\mysql path, directory structure: D:\mysql\mysql-5.6.33-winx64.

1. Configure my.ini file.

Create a new configuration file in the directory D:\mysql\mysql-5.6.33-winx64\(note that this directory should be your own directory, I downloaded version 5.6 here, if you downloaded version 5.5, this directory is different), the file name is my.ini, and then copy the following configuration code to my.ini (the path in the code should be changed to your own file storage path). As shown in the figure:

Code:

[mysql]#Set mysql client default character set default-character-set=utf8 [mysqld]#Set port 3306 port = 3306 #Set mysql installation directory basedir=D:\mysql\mysql-5.6.33-winx64\data#Set mysql database data storage directory datadir=D:\mysql\mysql-5.6.33-winx64\data#Maximum number of connections allowed max_connections=200#Character set used by server defaults to 8-bit encoded latin1 character-set-server=utf8#Default storage engine to be used when creating new tables default-storage-engine=INNODB

2. Install MySQL service:

Run this cmd.exe under the C:\Windows\System32 directory as an administrator. Note that you must run it as an administrator, otherwise you cannot install it successfully.

Open cmd window as administrator, switch directory to bin directory where you extracted files, and then enter mysqld install Enter to run on the line, note that mysqld, not mysql. Enter the command in my picture directly in cmd. As shown in the figure:

Successful installation as shown in the figure:

After successful installation, someone directly entered mysql -uroot -p and then entered, still prompted to connect to the database, why is this? This is because after installing mysql successfully, you have to open mysql service to use it.

3. Start MySQL service.

① Control Panel-> Management Tools-> Services-> mysql-> Start.

You can now use MySQL services. After installation, if there is an error 1066 during startup, it is because of a problem with my.ini configuration. Focus on seeing if the path in my.ini has been modified to its own path.

When you enter the command mysql -uroot -p to connect to the database, you will be prompted to enter the password. The password for root is empty by default. Just press Enter directly.

Thank you for reading! After reading the above, do you know how to install MySQL compressed version? I hope the content of this article is helpful to everyone. If you want to know more about related articles, please pay attention to the industry information channel.

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.