○ 报错:
Error: Unable to find a match: mysql-community-server
○ 解决
yum module disable mysql
○ 重复安装mysql操作,报错
Error: GPG check FAILED
○ 解决:
yum install mysql-community-server --nogpgcheck
启动mysql
systemctl start mysqld.service
查看mysql启动状态
service mysqld status
查看初始密码
grep 'password' /var/log/mysqld.log
进入数据库
mysql -u root -p
进入前修改初始密码
- service mysqld stop
- find / -name my.cnf
- vi “结果”
添加:
skip-grant-tables
● 重启mysqlservice mysqld start
● 进入/回车mysql -u root -p
● show databases;show databases;
● 修改用户密码update user set authentication_string=password('root') where user='root';
● 修改配置文件my.cnf,删除skip-grant-tables,
● 重启,再登录
查看防火墙是否已开放3306端口
firewall-cmd --query-port=3306/tcp
设置3306端口为永久开放
firewall-cmd --add-port=3306/tcp --permanent
查看firewalld状态,发现当前是dead状态,即防火墙未开启
systemctl status firewalld
关闭防火墙
systemctl stop firewalld
重启防火墙(设置了新的端口记得先关闭,再重启)
systemctl start firewalld
如果是阿里云ECS,记得查看云安全组规则是否开放了3306端口,如果没有,记得加上
测试连接失败
● 解决
● 依次执行 mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
● 修改密码step 1: SET PASSWORD = PASSWORD('your new password');
step 2: ALTER USER 'root' PASSWORD EXPIRE NEVER;
step 3: flush privileges;
● 执行:执行 use mysql;
执行 update user set host = '%' where user = 'root';
执行 FLUSH PRIVILEGES;