What is the installation method of mysql using zip?

Mysql installation method using zip: First download the zip file and extract it locally; then modify the configuration file and copy the relevant content; then enter cmd, run the console as an administrator, and run the mysqld install command; finally set the initial Password and execute the [mysql -u root -p] statement.

Related free learning: mysql database(Video )

Mysql installation method using zip:

I have always been accustomed to using MySQL installation files (.exe), and I downloaded one today. The zip version of MySQL encountered some problems during the installation process, as follows:

1. Download the installation-free zip file from the MySQL official website (http://dev.mysql.com/downloads/mysql/) (This article uses mysql-5.7.14-winx64.zip as an example)

2. Extract the zip file to the local area. This article extracts it to the following directory: D:\softwares\mysql-5.7.14-winx64

3. Create a new configuration file (my.ini) to configure character set, port and other information to overwrite the original configuration file (my-default.ini). Of course, you can also modify this default configuration file. Create a new folder data to store MySQL data. As follows:

       

                                                                                                                                                                                                     

# [MySQL]

#Set the MySQL client default character set

Default-Character-set = UTF8

[mysqld]

#Set 3306 port
Port = 3306
      # Set the installation directory of mysql

        basedir=D:\\softwares\\mysql-5.7.14-winx64
        # Set the directory where the data of the mysql database is stored
            datadir=D:\ \softwares\\mysql-5.7.14-winx64\\data

      # Maximum number of connections allowed
        max_connections=200
            # The character set used by the server defaults to UTF8

            character-set -Server = UTF8

#----------
Default-Storage -ngine = InnoDB

# 4. Enter CMD to run the console as an administrator, Enter the MySQL path (D:\softwares\mysql-5.7.14-winx64\bin) and run the mysqld install command. Note: You need to run as an administrator here, otherwise the prompt will be as follows:

5. After the installation is successful, it will be as follows:

Start the mysql service and think everything is ok. The results are as follows:

6. Search the Internet for the error message 3534. Some people say that starting from 5.7.6, you need to execute the mysqld --initialize method (http://www.mamicode.com/info-detail-1150164.html). The solution is as follows:

1) Execute the mysqld -remove command to delete the previous wrong installation, otherwise it will prompt that it has been installed

2) Execute the mysqld --initialize command and then execute mysqld install, and then Execute net start mysql to start MySQL, everything is ok

# -p Enter and enter the password to log in to mysql

         

                                          ” datadir does not use "\\" to represent the path. When executing the mysqld --initialize command, an error will be reported:

     

  9. You can set environment variables and start cmd Enter the mysql -u root -p password to log in to mysql without switching to the bin directory of the mysql installation directory.

This article can set D:\softwares\mysql-5.7.14-winx64\bin to In the environment variable path, after starting cmd, you can directly enter the command to connect to mysql, as follows:

         

The above is the detailed content of What is the installation method of mysql using zip?. For more information, please follow other related articles on the PHP Chinese website!