mysql 8.2 安装和赋权

 1 C:\Users\Administrator>mysql -u root -p
 2 Enter password: ******
 3 Welcome to the MySQL monitor.  Commands end with ; or \g.
 4 Your MySQL connection id is 15
 5 Server version: 8.2.0 MySQL Community Server - GPL
 6 mysql> show databases;
 7 mysql> use mysql;
 8 mysql> select host, user, plugin,  authentication_string, password_expired from user;
 9 mysql> create user spark@'%' identified by '123456' with grant option;
10 mysql> grant all privileges on *.* to 'spark'@'%' with grant option;
11 mysql> flush privileges;
12 Query OK, 0 rows affected (0.78 sec)