Detailed explanation of MySQL 8.0.18 commands

Open the folder C:\web\mysql-8.0.11 that you just unzipped, create a my.ini configuration file in the folder, and edit my.ini to configure the following basic information:

[client]
# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
# Set port 3306 port = 3306
#Set the installation directory of mysql basedir=C:\\web\\mysql-8.0.11
#Set the storage directory of the MySQL database data. MySQL 8+ does not require the following configuration, the system can generate it by itself, otherwise an error may be reported # datadir=C:\\web\\sqldata
# Maximum number of connections allowed max_connections=20
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

Open the cmd command line tool as an administrator (failure to open it as an administrator will cause the database installation to fail later) and switch directories:

cd C:\web\mysql-8.0.11\bin

Initialize the database:

mysqld --initialize --console
//Remember the APWCY5ws&hjQ after root@localhost. APWCY5ws&hjQ is the initial password. You will need it for subsequent logins. You can also change the password after logging in.

Enter the following installation command:

mysqld install

To start, enter the following command:

net start mysql

Log in to MySQL:

mysql -u root -p

Then enter your login password.

To change your password:

ALTER USER 'root'@'localhost' identified by '123';

Create the database:

create database 創建的數據庫名稱;

Switch database:

use 數據庫名;

Delete the database:

drop database 數據庫名;

Exit MySQL:

quit

Summarize

The above is the MySQL 8.0.18 command that I introduced to you. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!