mysql 8.2 安装和赋权

合集 - mysql+kafka+python+pyspark+jupyter+VScode+anaconda(7)

1.mysql 8.2 安装和赋权2023-11-04

2.windows开发环境准备：python+java+anaconda+jupyter+VScode安装2023-11-073.jupyter自动感知-nbextension2023-11-104.jupyter notebook 的默认起始位置和默认浏览器修改2023-11-115.开始pyspark------------jupyter notebook 读取CSV文件2023-11-116.Caused by: java.io.IOException: Cannot run program "python3": CreateProcess error=2, 系统找不到指定的文件。2023-11-117.导入jar包，比如导入pymysql2023-11-12

收起

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目录