mysql 8.2 安装和赋权

1 - 下载安装包

下载地址： https://dev.mysql.com/downloads/mysql/

 

2- 安装

制定目录安装，略。

3- 登录，创建用户并赋权

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

 4- 远程登录

 

注意修改安装的bin目录