Mysql 5.7.14 installation and configuration graphic tutorial, mysql5.7.14

Mysql 5.7.14 installation and configuration graphic tutorial, mysql5.7.14

You need to install Mysql on your local machine. First, record the installation process as follows.

1. Download Software

1. Enter the mysql official website, log on to your oracle account, download Mysql-5.7.14,: http://dev.mysql.com/downloads/mysql/

2. decompress the downloaded file to the specified directory, the small editor will decompress the file in C: \ Users \ Administrator \ Desktop \ mysql-v5.7.14

Ii. illustrated Installation Process

1. Enter the installation page

2. Select "I accept ......", Next step

3. Select a type

4. Installation in progress

5. Installation successful

Iii. Installation Process

1. First configure the environment variable path and configure C: \ software \ Mysql \ mysql-5.7.14-winx64 \ bin to your own path.

2. Copy the my-default.ini in the extract path and change the name to my. ini, as shown in.

3. open the file my. ini and add the following content:

[mysqld]basedir=C:\\software\Mysql\mysql-5.7.14-winx64datadir=C:\\software\Mysql\mysql-5.7.14-winx64\dataport=3306

Basedir: the mysql decompression path.
Datadir:Subsequent initialization and other data will be saved in this directory, and a new data folder will be created under this directory.
Port:Indicates the port number to connect to the database.

Iv. initialize database configuration information
1. run windows command line as an administrator
2. Enter the mysql decompression directory:

Reminder: Enter the bin directory. Otherwise, an error will occur in subsequent operations.

3. Execute initialization. The initial root password is generated, as shown in:

Remember the generated initialization password.

4. Quasi-pass Mysql services. Run the command: mysqld -- install MySQL

The mysql service is successfully installed.

The above is how to install and configure mysql 5.7.14, and I hope it will help you learn it.