当前位置：网站首页>MySQL installation configuration -version 8.0 -windows

[mysql]
#  Set up mysql Client default character encoding form 
default-character-set=utf8mb4
[mysqld]
# Set the port number , Default 3306
port = 3306
#  Set up mysql Installation directory 
basedir=D:\SoftWare\Devlopment-tools\mysql-8.0.22-winx64
#  Set up mysql Database data storage directory 
datadir=D:\SoftWare\Devlopment-tools\mysql-8.0.22-winx64\data
#  Set the maximum number of connections 
max_connections=200
#  Number of connection failures allowed 
max_connect_errors=10
#  The character set used by the server defaults to utf8mb4
character-set-server=utf8mb4
#  The default storage engine that will be used when creating a new table 
default-storage-engine=INNODB
#  By default “mysql_native_password” Plug in authentication 
#mysql_native_password
default_authentication_plugin=mysql_native_password
[client]
#  Set up mysql The default port when the client connects to the server 
port=3306
default-character-set=utf8mb4

3、 Modify corresponding position 、 After modifying the port number and other information, save the file to the root directory

3、 ... and 、 register mysql service , And initialization mysql

1、 register mysql service

Administrator permission open CMD, Enter the following line by line （ The path location can be modified by itself ）

cd D:\SoftWare\Devlopment-tools\mysql-8.0.22-winx64\bin D: mysqld --install

Get the information in the red box below , Registered successfully

2、 initialization mysql

Administrator permission open CMD, Enter the following line by line （ The path location can be modified by itself ）

cd D:\SoftWare\Devlopment-tools\mysql-8.0.22-winx64\bin D: mysqld --initialize-insecure

The root directory will be added data The folder is shown in the figure below

3、 Check after initialization root Temporary password

open data Under the document err Postfix file

Search for keywords [email protected]

If it is [email protected] is created with an empty password ! That is to generate a temporary password , Direct access record , The password is empty. , Setting password in

If it's this , You can use the temporary password to login and then modify

Four 、 start-up mysql, Set auto start

1、 start-up mysql

Administrator permission open CMD, Enter the following line by line （ The path location can be modified by itself ）

cd D:\SoftWare\Devlopment-tools\mysql-8.0.22-winx64\bin
D:
net start mysql

Start successfully as shown in the figure below

2、 Set auto start

open Windows Task manager , Open the service and find mysql service , Change the startup type to automatic startup

5、 ... and 、 Connect login

cd D:\SoftWare\Devlopment-tools\mysql-8.0.22-winx64\bin
D:
    mysql -u root -p

notes ：mysql Common commands for installation and configuration ：

# register mysql service 
mysqld --install

# remove mysql service 
mysqld --remove

# initialization mysql
mysqld --initialize-insecure

# start-up mysql service 
net start mysql 

mysql -u  user name  -h  Database address  -p # Log in to the database 

# Exit database 
quit 

# close mysql service 
net stop mysql

mysql The installation and configuration of is over here ,thankyou.

mysql Management software Navicat See another article for usage

原网站

版权声明
本文为[fenghuashao]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207211754342813.html