官网下载mysql:https://dev.mysql.com/downloads/mysql/
下载后用cmd进入解压后文件的bin目录
mysqld install
mysqld --initialize-insecurenet start mysql
mysqladmin -u root -p password
mysql -uroot -proot
mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> \q
Bye
mysql -uuser -ppassword
mysql> CREATE DATABASE db;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.00 sec)
mysql>