![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
kabuqinuo_77
这个作者很懒,什么都没留下…
展开
-
mysql主从同步配置
1.准备两台服务器,安装mysql, 例如以192.168.245.101作为主库,192.168.245.100作为从库,centos7安装mysql参考centos7安装mysql2.修改主库/etc/my.cnf文件,在[mysqld]下添加如下,并重启mysql服务3.修改从库/etc/my.cnf,在[mysqld]下添加server-id=2,并重启mysql服务4.在主库上以root用户登录mysql,并创建用于备份的账号replication_user,密码设置1234565.主原创 2021-11-25 23:01:03 · 162 阅读 · 0 评论 -
centos7安装mysql
1.下载并安装mysqlwget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmrpm -ivh mysql-community-release-el7-5.noarch.rpmyum install mysql-community-server2.重启mysql服务service mysqld restart3.修改root用户密码/usr/bin/mysqladmin -u root password原创 2021-11-14 21:02:16 · 545 阅读 · 0 评论