![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
文章平均质量分 62
Joe-Li
这个作者很懒,什么都没留下…
展开
-
centos7 mysql5.7主从库配置
centos7 mysql5.7主从库配置主库配置从库配置从库常见异常如何在Centos7在线安装部署mysql5.7,点击查看教程主库配置1.修改/etc/my.cnf文件配置 //编辑文件 vim /etc/my.cnf配置2.在[mysqld]下方添加以下配置[mysqld]#服务器id (主从必须不一样)server-id=10001#打开日志(主库需要打开),这个mysql_log-bin名称可自定义、可加路径log-bin=mysql-log-bin#从库可以同步的库原创 2021-01-13 17:11:24 · 201 阅读 · 0 评论 -
Centos7在线安装部署mysql5.7
Centos7在线安装部署mysql5.7安装mysql安装依赖再次安装mysql服务查看root默认密码修改密码登录mysql修改密码出现以下错误需先修改规则再次修改密码授权访问权限安装mysql yum -y install mysql-community-server出现以下错误,则需先安装依赖安装依赖 //下载依赖 wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm //安装依赖 rpm原创 2021-01-13 12:11:00 · 232 阅读 · 0 评论 -
mysql5.7错误 this is incompatible with sql_mode=only_full_group_by问题解决
centos7环境的mysql5.7执行下group语句select tb1.name,sum(1) as numfrom table_1 tb1 GROUP BY tb1.name 错误提示:SELECT list is not in GROUP BY clause and contains nonaggregated column ‘***’ which is not functionally dependent on columns in GROUP BY clause; this is i原创 2020-07-24 14:07:14 · 248 阅读 · 0 评论 -
Centos7 修改mysql5.7最大连接数
版本:centos7,mysql5.71.编辑mysql配置文件//编辑mysql配置文件vim /etc/my.cnf//在[mysqld]下添加max_connections=100002.编辑mysqld.service配置文件//编辑/usr/lib/systemd/system/mysqld.service配置文件vi /usr/lib/systemd/system/mysqld.service//在尾部添加LimitNOFILE=65535LimitNPROC=原创 2020-06-24 16:57:30 · 1718 阅读 · 1 评论 -
WARN: Establishing SSL connection without server's identity verification is not recommended.
WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default i...原创 2018-12-14 10:27:35 · 545 阅读 · 0 评论