mysql系列报错

1、ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

原因：登录我哥的数据库，已经被设置了账号密码，需要使用已知的用户名和密码登陆
解决：
[root@szx ~]# mysql -u root -p

2、bash: mysql: command not found…

[root@192 ~]# mysql -h 192.168.8.128 -p 3306 -u root -pszb521
bash: mysql: command not found...
原因：远程登录连接，显示mysql命令没找到
解决：没有安装mysql导致
yum install -y mysql
一般用mysql --version 测试本地是否有mysql
whereis mysql 查看mysql的路径

3、ERROR 1130 (HY000): Host ‘192.168.8.141’ is not allowed to connect to this MariaDB server

报错:root@ubuntu:/etc/apt# mysql -h 192.168.8.128 -u root
ERROR 1130 (HY000): Host '192.168.8.141' is not allowed to connect to this MariaDB server

解决办法：
没有设置远程访问权限
MariaDB [mysql]> grant all on *.* to 'root'@'%' identified by mysql521 with grant option;
flush privileges;		# 刷新缓存

修改账号密码：
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

持续更新