MySQL 5.7的Linux下的安装与使用（总结）

最新推荐文章于 2025-03-24 14:40:18 发布

永不秃头小魔王

最新推荐文章于 2025-03-24 14:40:18 发布

阅读量196

点赞数

本文链接：https://blog.youkuaiyun.com/qq_32780741/article/details/106268842

版权

安装命令

rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

#查看mysql状态
systemctl status mysqld
#启动mysql
systemctl start mysqld

#查找root的登陆密码
cat /var/log/mysqld.log | grep password
#root登陆
mysql -u root -p
#修改Mysql密码策略，默认是1，即MEDIUM
set global validate_password_policy=0;
#指定了密码中数据的长度
set global validate_password_length=1;
#修改密码
alter user root@localhost identified by 'fwc999';
允许数据表被其他主机远程登录
update user set host = '%' where user = 'root';
#使设置立即生效
flush privileges;

GRANT replication slave ON *.* TO 'slave'@'%' IDENTIFIED BY 'fwc927';
CREATE USER 'slave'@'%' IDENTIFIED BY 'fwc927';

change master to master_host='node1', master_port=3306, master_user='master', master_password='fwc927';