Installation, configuration and uninstallation of MySQL 8.0 in Windows environment

name：Path
value: C:\Program Files\MySQL\mysql-8.0.17-winx64\bin

[mysqld]
# Port number (default: 3306)
port=3306
# Set the installation directory of mysql basedir=C:\Program Files\MySQL\mysql-8.0.17-winx64
# Set the storage directory of mysql database data datadir=C:\Program Files\MySQL\mysql-8.0.17-winx64\data
# Maximum number of connections allowed max_connections=1000
# Maximum waiting time (non-interactive connection: jdbc connection database)
wait_timeout=60
# Maximum wait time (interactive connection: mysql client)
interactive_timeout=600
# Set the default time zone default-time_zone='+8:00'

// 1. Initialize the MySQL database C:\Program Files\MySQL\mysql-8.0.17-winx64\bin> mysqld --initialize --console
// If "initializing of server has completed" appears, or if many files are generated in the data folder, it means that the initialization is successful. // A random password will be displayed on the console after root@localhost: // 2. Install MySQL service C:\Program Files\MySQL\mysql-8.0.17-winx64\bin> mysqld install
// If you do not use the default service name, enter mysqld install mysql8.0 and specify the service name as mysql8.0
// If "Service successfully installed." appears, or there is a MySQL service in the service, it means that the installation is successful. // 3. Start the MySQL service C:\Program Files\MySQL\mysql-8.0.17-winx64\bin> net start mysql
// Start mysql with the specified service name: net start mysql8.0

// 4. At this point, the installation is complete. You can log in and try. The password is the random password generated when the database is initialized. C:\Program Files\MySQL\mysql-8.0.17-winx64\bin> mysql -uroot -p
// Start mysql on the specified port: mysql -uroot -P3305 -p

// 5. Change the root passwordmysql> alter user 'root'@'localhost' identified by 'root';

// 1. Stop MySQL
D:\ProgramFiles\MySQL\mysql-8.0.16-winx64\bin> net stop mysql
// Stop mysql with the specified service name: net stop mysql8.0

// 2. Uninstall MySQL
D:\ProgramFiles\MySQL\mysql-8.0.16-winx64\bin>mysqld remove
// Uninstall mysql with the specified service name: mysqld remove mysql8.0

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL