MySQL 8.0. 12 installation and uninstallation tutorial details

1. MySQL version 8.0. 12 installation steps.

1. Download

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

2. Decompress

Extract mysql-8. 0.12-winx64.zip into D:/mysql directory

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

d:

cd\

cd mysql

cd bin

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

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

d:\ mysql\ bin\ mysqld--install ES50xxx is the service name, not written as the default service name mysql.

net start mysql Start 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; Establish a database

6. Exit Uninstall

mysql > exit exit client

d:\nysql\bin > net stop mysql out of service

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