Detailed installation and uninstallation tutorial for MySQL 8.0.12

1. Installation steps for MySQL 8.0.12 version.

1. Download

https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.12-winx64.zip

2. Unzip

Unzip mysql-8.0.12-winx64.zip to the D:/mysql directory

3Open the cmd command console and enter the following command.

d:

cd\

cd mysql

cd bin

d:\mysql\bin>mysqld --initialize-insecure Initialize the database directory, the account is root, and there is no password. After execution, there will be an additional data folder in the mysql directory.

4. Install the database system service and enter the following command.

d:\mysql\bin\mysqld --install xxx xxx is the service name. If it is not written, the default service name is mysql.

net start mysql starts the database service

5. Log in to the database server

d:\mysql\bin>mysql -uroot Direct login without password

mysql>select version(); View the current version number

mysql>show user(); View login account

mysql>show databases; View all databases

mysql>create database db; Create a database

6. Exit uninstall

mysql>exit Exit the client

d:\nysql\bin>net stop mysql to stop the service

d:\mysql\bin>mysqld --remove Uninstall service

The above is a detailed installation and uninstallation tutorial of MySQL 8.0.12 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!