在线安装方式:
步骤一:
rpm -ivh https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
步骤二:
yum install -y mysql-server
步骤三:
systemctl start mysqld
步骤四;
systemctl enable mysqld
步骤五:
systemctl stop firewalld
或者 开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
步骤六: 初始化密码
grep 'temporary password' /var/log/mysqld.log
Tip:如果默认密码登陆不上操作
修改 /etc/my.cnf,在 [mysqld] 小节下添加一行:skip-grant-tables=1
systemctl restart mysqld
mysql:mysql -u root
步骤七:修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Tip:如果报错操作
use mysql;
update user set authentication_string = password('123456'), password_expired = 'N', password_last_changed = now() where user = 'root';
步骤八:修改远程登陆权限
update user set Host='%' where User='root';
步骤九:刷新权限
FLUSH PRIVILEGES;
步骤十:重启mysql
systemctl restart mysqld