CentOS7.x 中安装MySQL5.7.6+ 密码是什么?两步解决

2016-11-4 Admin

Redhat Enterprise 7/ CentOS 7/Oracle 7/安装MySQL5.7后数据库登不上解决方法: 1.找到/var/log/mysqld.log中的初始密码 [root@_centos ~]# cat /var/log/mysqld.log |grep root@localhost 2016-11-02T14:56:37.580084Z 1 [Note] A temporary password is generated for root@localhost: UQ8eKVp_IA/I localhost: 后面的就是你的初始密码 2.设置...

阅读全文>>

评论(0) 浏览(779)

Emlog6.0 TagName错误

2016-11-4 Admin

Emlog6.0在MySQL5.x可能会出现不能添加标签错误 解决方法 执行SQL命令: ALTER TABLE `emlog_tag` CHANGE `gid` `gid` text COLLATE 'utf8_general_ci' NULL AFTER `tagname`;

阅读全文>>

评论(0) 浏览(776)

MySQL5.7.6+ Order By错误

2016-11-4 Admin

Expression #1 of ORDER BY clause is not in SELECT list, references column **' which is not in SELECT list; this is incompatible with DISTINCT 解决方法 在/etc/my.cnf中添加: sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

阅读全文>>

评论(0) 浏览(621)


Powered by emlog | Theme by BootStrap | Author by UbranGames | 苏ICP备14054908号-6 | sitemap | Load Time:3.01ms