Detailed introduction to the installation and configuration steps of MySQL5.7

This article introduces you to the MySQL5.7 step by step. ConfigurationThe detailed operation method is very good and has reference value. Friends in need can refer to it

1. Download of MySQL

1. Log in to the official website of MySQL to download the ZIP compressed package suitable for 64-bit systems

2. Unzip the installation package

Extract the downloaded ZIP compressed package to any folder (here: C:\mysql5.7).

3. Modify the configuration file

will unzip my- in the folder directory Rename the default.ini file to my.ini.

Open it with a text editor and clear the content (refer to the Internet):

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
#设置3306端口
port = 3306 
# 设置mysql的安装目录
basedir=C:\mysql5.7
# 设置mysql数据库的数据的存放目录
datadir=C:\mysql5.7\data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

.

Note:

basedir and datadir are replaced with their actual paths.

After the initial decompression of the MySQL5.7 version of the compressed package. The folder directory does not contain the data folder, don't worry, you will use the command to initialize it later. No need to manually create it

##Save after the modification is completed
Exit

.

4. Configure the environment

Variables Add C:\ mysql5.7\bin (Replace with the path to the actual bin directory here)

Note: Separate from the previous environment variables with;

5 , Install MySQL

Run the cmd window as administrator

Switch to the C:/mysql5.7/bin directory

Enter the following commands in order:

1. mysqld install Wait for the prompt that the installation is successful

2. mysqld --initialize Initialize the data directory

3. net start mysql Start the service

6. Change the password of root user

After completing the above five steps, run mysql -u root -p , Since the root user does not have a password by default, just press Enter to enter.

Error message:

ERROR 1045 (28000): Access denied

for

user'root'@'localhost'(using passw ord: NO)This is because the root user of mysql has not set a password. We need to temporarily ignore the permissions to set the password of the root user.

The operation method is as follows:

Add a line of statement skip_grant_tables under the [mysqld] entry in the configuration file my.ini

Save and exit, and restart the MySQL service without restarting MySQL The service was ineffective.

Run after restarting mysql -u root -p

Prompt to enter the password and press Enter to enter MySQL

Enter the following SQL statements in order

1.use mysql ; Display Database changed
2.update user set authentication_string=password("123456") where user="root"; The password in brackets is the password you want to set

3.flush privileges; Refresh the database , be sure to refresh

4.quit and exit


Delete skip_grant_tables
or

comment

in the configuration file my.ini
7. Some settings for the first login

It cannot be used directly when logging in to MySQL for the first time and needs to be reset again. Password, otherwise an error message will appear

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

Enter the command:

set password=password('123456');

Stay consistent with the password set in the previous step

After setting it up, MySQL can be used normally. At this time, the root user can only connect through the local machine, which is enough for learning.

If you need a remote connection, you need to set it up again

The SQL statement is as follows:

use mysql;
show tables;
select host,user from user;
update user set host='%' where user='root';
quit
net stop mysql
net start mysql

注：

host列指定了允许用户登录所使用的IP，%是通配符，设置为%则代表任意IP都可以访问root

The above is the detailed content of Detailed introduction to the installation and configuration steps of MySQL5.7. For more information, please follow other related articles on the PHP Chinese website!