- 安装MariaDB:
- yum install mariadb mariadb-server
- systemctl start mariadb.service #启动MariaDB
- systemctl stop mariadb.service #停止MariaDB
- systemctl restart mariadb.service #重启MariaDB
- systemctl enable mariadb.service #设置开机启动
- mysql_secure_installation#设置密码
- 出现1045错误:1045 (28000): Access denied for user 'root'@'192.168.0.57' (using password: YES)
- 这个错误是在进行远程连接的时候密码正确但是,进行远程授权的时候授权密码错误
- 出现1045错误:1045 (28000): Access denied for user 'root'@'192.168.0.57' (using password: NO)
- 这个错误是单纯的密码错误,就别纠结了
- 出现1130错误:1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server
- 这个错误是因为没有进行远程连接授权,给远程授权就行了
- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的MariaDB密码' WITH GRANT OPTION;
- flush privileges;
- 执行以上两句语句就能解决
- 出现2003错误是防火墙原因,是因为防火墙开启数据库端口没打开
Mariadb安装远程连接报错解决方案
最新推荐文章于 2024-06-19 11:46:01 发布