1.刚开始安装mysql参考这个：

　　　　https://blog.csdn.net/a116475939/article/details/74625377

2.修改密码

mysql> use mysql; #先把密码置为空字符串；（不让后面修改密码会报错）mysql> update user set authentication_string="" where user="root"; #这个刷新非常有必要；不让后面执行alter就会出错mysql> flush privileges;mysql> ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘密码‘;

3.创建用户以及赋权

mysql> create user ‘shenbo‘@‘%‘ identified by ‘$mima...‘;Query OK, 0 rows affected (0.21 sec)mysql> grant all privileges on *.* to ‘shenbo‘@‘%‘ ;Query OK, 0 rows affected (0.06 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)