Detailed explanation of the installation, configuration, startup and shutdown methods of the Mysql server

1. Download from official website:

https://dev.mysql.com/downloads/

Find MySQL Community Server and click

Click download, you can choose the download path, I downloaded it in the D drive:

After downloading, you need:
Create a new mysql.ini file content:

[mysql]

 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 to basedir=D:\java web\mysql\mysql-8.0.27-winx64

#Set the storage directory of mysql database data datadir=D:\java web\mysql\mysql-8.0.27-winx64\data

#Maximum number of connections allowed max_connections=200

 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

(Excerpt from notes)

Create a new data folder and create the same directory as bin: store data

2. After installation: Configure environment variables:

Mine is: D:\java web\mysql\mysql-8.0.27-winx64

In the settings of this computer, open the advanced properties environment variables:
path: Create a new D:\java web\mysql\mysql-8.0.27-winx64\bin:

Configured: Open the cmd command prompt as an administrator:

Type: mysqld install
Check if the installation is successful

3. Start and shut down the server

net start mysql //Start
net stop mysql //Close

You can also:
MySQL has been installed. The server needs to be started manually by entering the cmd command. Open the command window and enter the command to start the server: mysqld --console

You can also: Find mysql in the service and start it manually

4. Log in to MySQL server

mysql -u username -p user password to open the command window and log in as the super administrator:
Enter the command mysql -u root -p and press Enter. You will be prompted to enter a password. The password is empty.

5. Change password:

Enter in mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your-password';
ALTER USER 'root'@'localhost' IDENTIFIED BY '密碼數字輸入或字母';

The password is: your-password

This is the end of this article about the installation, configuration, startup and shutdown methods of the MySQL server. For more relevant MySQL installation and configuration content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!