1、查看系统是否存在默认数据库Mariadb。存在 转2
shell> rpm –qa | grep mariadb;
2、卸载数据库
shell> Rpm –e –nodeps mariadb-libs-version;
- 下载安装包
- 安装安装包
shell> rpm -ivh mysql-community-server-version-distribution-arch.rpm
必须安装的包:mysql-community-server
, mysql-community-client
, mysql-community-libs
,mysql-community-common
, mysql-community-libs-compat
安装顺序:common —— libs —— libs-compat —— Client —— Service
- 是否安装成功检测
shell> rpm –qa | grep mysql;
- 启动服务
shell> service mysqld start;
查看初始密码
shell> sudo grep 'temporary password' /var/log/mysqld.log
修改密码
shell> mysql -uroot –p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
- 开启防火墙
开启端口
firewall-cmd --zone=public --add-port=80/tcp –permanent
重启防火墙
firewall-cmd –reload
8、1130错误
错误:ERROR 1130: Host '192.168.1.3' is not allowed to connect to thisMySQL serve
错误1130:主机192.168.1.3”不允许连接到thismysql服务
原因:被连接的数据不允许使用 192.168.1.3访问,只允许是用 localhost;
解决方案
总体运行语句:
mysql -u root -p
mysql>use mysql;
mysql>select 'host' from user where user='root';
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host' from user where user='root';
运行完毕后再次连接测试,若还不行重启mysql服务,或是直接重启电脑