用户授予权限
参考
https://blog.csdn.net/qq_41097820/article/details/87643357
https://blog.csdn.net/shiyong1949/article/details/73887709
https://blog.csdn.net/paullinjie/article/details/80343633
1、root用户登陆mysql
2 查看 用户权限
SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
或者
select host,user from mysql.user;
3 授予权限
update user set Select_pri='Y' where user='root_ssm' // 单个
flush privileges;
或者
mysql> grant all on *.* to 'shiyong'@'192.168.%'; // 赋予所有权限
mysql> flush privileges;
4 重启 mysql