## this authentication plugin is not supported
MySQL8的默认密码认证方式使用caching_sha2_password，所以访问会提示this user requires mysql native password authentication。
解决方案:etc/my.cnf 添加如下修改
```
[mysqld]
default-authentication-plugin=mysql_native_password
```
## 不能已root 启动
创建mysql账号和组 并授权
```
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysq /usr/local/mysql
chmod 755 /usr/local/mysql
```
免密登陆
```
mysqld_safe --skip-grant-tables
update user set authentication_string='' where user='root';
```
更改密码
```
use mysql; //选择数据库
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; //更改加密方式
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码'; //更新用户密码
FLUSH PRIVILEGES; //刷新权限
```