mysql 错误解决方案

mysql 错误解决方案

MySQL said: Access denied for user ‘root’@‘niuniudeair.addom.xinaogroup.com’ (using password: YES)

修改密码 alter user ‘root’@‘%’ identified by ‘root’; flush privileges;
重启mysql

解决linux mysql命令 bash: mysql: command not found 的方法

没有配置环境变量 输入：alias mysql=/usr/local/mysql/bin/mysql 再输入mysql --version
验证命令是否有效

MySQL 连接出现 Authentication plugin ‘caching_sha2_password’ cannot be loaded

#修改加密规则 alter user ‘root’@‘%’ identified with mysql_native_password by ‘root;

mysql无法远程访问

1. vim /etc/my.cnf
#skip-grant-tables
添加后： 2. 重启服务 mysql命令 systemctl restart mysqld.service

直接进服务器
3. use mysql 切换账号

MySQL 8.0 不支持
4. grant all privileges on . to ‘root’@‘%’ identified by
‘q17dSS^KqPnp’ with grant option 这种写法了

正确的写法是先创建用户 5. CREATE USER ‘root’@‘%’ IDENTIFIED BY 'Hadoop3 再给用户授权
6. grant all privileges on . to ‘root’@‘%’

ERROR 1290 (HY000): The MySQL server is running with the
–skip-grant-tables option so it cannot execute this statement 在安装mysql，修改root密码时候出错 原因：权限没有刷新 解决：7. flush privileges

8. ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY
‘password’ 更新一下用户的密码