Mysql 5.7.20 win64 installation and configuration method, 5.7.20win64

Mysql 5.7.20 win64 installation and configuration method, 5.7.20win64

Mysql-5.7.20-winx64.zip installation package without Installation Steps:

Https://dev.mysql.com/downloads/file? Id = 473309

Environment variable settings:

Put C: \ Program Files \ mysql-5.7.20-winx64 \ bin in Path

Right-click the step after -- command prompt (Administrator) -- cd C: \ software \ mysql \ mysql-5.7.20-winx64 \ bin:

1. mysqld install

2. initialize the mysql data DIRECTORY (this directory is not available after mysql-5.7 extraction) and generate the password: mysqld -- initialize-insecure success is unresponsive

3. Execute net start mysql on the dos interface (any directory)

4. Execute mysql-uroot on the dos interface (any directory) to log on as the root user.

5. update user set authentication_string = password ('000000') where user = 'root' and Host = 'localhost'; set password to 123456

#### Update MySQL. user set authentication_string = password ('root') where user = 'root ';

6. mysql-u root-p; (log on to mysql with a password)

7. net stop mysql (stop mysql) -- mysqld remove (remove mysql), and try to install

1. Header: the name of each column;
2. Column: a set of data with the same data type;
3. Row (col): each row is used to describe the specific information of a person/object;
4. Value: the specific information of the row. Each value must be of the same data type as the column;
5. Key: A table is used to identify a specific person or object. The key value is unique in the current column.

Log on to MySQL

When the MySQL service is running, you can log on to the MySQL database using the client tool that comes with MySQL. First, open the command prompt and enter the name in the following format:

Mysql-h host name-u user name-p

• -H: This command is used to specify the MySQL host name to be logged on to the client. This parameter can be omitted when logging on to the current machine;
• -U: the user name to log on;
• -P: tells the server that a password will be used for Logon. If the username and password to be logged on are empty, ignore this option.

Take logging on to the MySQL database just installed on the local machine as an example. Enter mysql-u root-p in the command line and press enter to confirm. If the installation is correct and MySQL is running, the following response is returned:

Enter password:

If the password exists, enter the password to log on. If the password does not exist, press enter to log on. According to the installation method described in this article, the root account has no password by default. After successful logon, you will see the prompt message of Welecome to the MySQL monitor.

Then the command prompt will always wait for the command input with a blinking cursor in mysql>, enter exit or quit to log out.

Create a database

You can use the create database statement to create a database. The command format is as follows:

Create database name [other options];

For example, to create a database named samp_db, run the following command on the command line:

create database samp_db character set gbk;

To display Chinese characters at a command prompt, specify the database character encoding as gbk by using character set gbk during creation. When the creation is successful, the Query OK and 1 row affected (0.02 sec) will be returned.

Note: The MySQL statement ends with a semicolon (;). If a semicolon (;) is not added at the end of the statement, the command prompt will prompt you to continue to enter the statement (there are some special cases, but the extra points are certainly not wrong );

Tip: You can run the show databases command to check which databases have been created.

Use mysqladmin:

Open the command prompt interface and execute the command:Mysqladmin-u root-p password New password

After the command is executed, the system prompts you to enter the old password to change the password. If the old password is empty, press enter to confirm the password.

MySQL Workbench official introduction: http://www.mysql.com/products/workbench/

MySQL Workbench download: http://dev.mysql.com/downloads/tools/workbench/

Summary

The above section describes how to install and configure mysql 5.7.20 win64. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!