MySQL 5.7.13 winx64 installation and configuration method graphic tutorial (win10)

This article shares with you the graphic tutorial of MySQL 5.7.13 winx64 installation and configuration method for your reference. The specific content is as follows

download

Address: http://dev.mysql.com/downloads/file/?id=463242

Install

1. Unzip the downloaded mysql-5.7.13-winx64.zip to the directory you need to install (eg: D:\mysql);

2. Configure the my_default.ini in the decompressed directory and name it my.ini

The relevant configurations are as follows:

# These are commonly set, remove the # and set as required.
basedir = D:\mysql5.7 (mysql installation directory)
datadir = D:\mysql5.7\data (the directory where data is saved in mysql, set by yourself)
port = 3306 (mysql's port number)
# server_id = .....

3. Add environment variables

Add D:\mysql5.7\bin to the environment variables;

eg:......;D:\mysql5.7\bin

4. Initialization

Enter the MySQL bin folder
mysqld –install
mysqld –initialize –console (There is a series of alphanumeric characters after root@localhost:. This is the random password that MySQL automatically generates for you. Be sure to write it down. We will use it when we log in to the MySQL database later).
PS: Use -initialize to generate a random password, and use -initialize-insecure to generate an empty password. The data folder will be automatically generated after initialization, so you don’t need to create a new one yourself.

5. Start mysql

net start mysql

6. Enter msyql and set a password

D:\mysql5.7\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password('your own password');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>

Connect to remote mysql (connect mysql between two win7 LAN)

Error in connection:

1. Error description: When setting remote permissions for root: ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' (it is best not to use this, use the following method to authorize).
Solution: The setting has been successful.

2. Authorization in MySQL:

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 
mysql> flush privileges;

3. Turn off the firewall (at the same time, pay attention to the correctness of the IP address of win7 as the mysql carrier and the LAN IP)

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.