Explain some simple configurations of mysql8.0

This article will introduce you to some simple configurations of mysql-8.0, I hope it will be helpful to you!

mysql-8.0 Some simple configuration

Download

After downloading, unzip the zip and put it in a directory , configure the environment variables

Configuration file

After downloading, there is no my.ini file (or my-default.ini) in the downloaded root directory, and there is no my. ini file, you can create it yourself. Add my.ini

[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=C:\Program Files\mysql-8.0.12-winx64
# 设置mysql数据库的数据的存放目录
datadir=D:\mysql\data
# 允许最大连接数
max_connections=200
# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
max_connect_errors=10
# 服务端使用的字符集默认为UTF8
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证
default_authentication_plugin=mysql_native_password
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8

in the installation root directory. Note that basedir is my local installation directory and datadir is the location where my database data files are stored. Each configuration needs to be configured according to your own environment.

Initialize the database

Execute the command in the bin directory of the MySQL installation directory:

mysqld --initialize --console

After the execution is completed, the initial default password of the root user will be printed

C:\Program Files\mysql-8.0.12-winx64\bin
λ mysqld --initialize --console
2018-07-28T08:09:39.819831Z 0 [System] [MY-013169] [Server] C:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) initializing of server in progress as process 8624
2018-07-28T08:09:46.120948Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: thbVf;1w7(Zy
2018-07-28T08:09:48.278535Z 0 [System] [MY-013170] [Server] C:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) initializing of server has completed

thbVf;1w7(Zy is the initial password (excluding the first space)

If you delete the initialized datadir directory and execute the initialization command again, it will be regenerated

Installation service

Execute the command in the bin directory of the MySQL installation directory (open the cmd command line as an administrator)

mysqld --install [服务名]

You don’t need to write the service name after , the default name is mysql. Of course, if you need to install multiple MySQL services on your computer, you can use different names to distinguish them, such as mysql5 and mysql8.

After the installation is completed, you can use the command net start mysql starts the MySQL service.

C:\Program Files\mysql-8.0.12-winx64\bin
λ mysqld --install
Service successfully installed.
C:\Program Files\mysql-8.0.12-winx64\bin
λ net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

Change password

Execute the command in the bin directory of the MySQL installation directory: mysql -u root -p

 At this time, you will be prompted to enter the password. After entering the initial password just now: Change the password as follows

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

Result

C:\Program Files\mysql-8.0.12-winx64\bin
λ mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.12
Copyright (c) 2000, 2018, 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> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.08 sec)
mysql> exit

Recommended learning: "mysql video Tutorial》

The above is the detailed content of Explain some simple configurations of mysql8.0. For more information, please follow other related articles on the PHP Chinese website!