Linux发行版centos 6升级kangle默认的mysql5.6为mysql5.7版本的详细一键脚本教程，构造大概升级请酌情考虑

小樱

升级后无法新建mysql用户提示，请注意执行修复
#3009 - Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50647, now running 50729. Please use mysql_upgrade to fix this error.

请看此帖解决方案
https://bbs.itzmx.com/thread-95487-1-1.html

本帖教程对应环境为centos6.10测试

某些该死的程序可能要5.7的mysql数据库，比如说FlarumChina，但是mysql构造大改，，很多程序又不支持5.7，所以用作空间销售等升级到5.7是不推荐不适合的。


注意，本方法为全新安装环境后立即升级，不保留任何数据库，会丢失数据，请不要在已经运行网站的情况下使用。

1. yum -y remove mysql mysql*
   
2. rm -rf /var/lib/mysql/*
   
3. yum -y install mysql-libs
   
4. rpm -ivh http://github.itzmx.com/1265578519/repo/master/CentOS/5.7/mysql57-community-release-el6-7.noarch.rpm
   
5. rm -rf /etc/yum.repos.d/mysql-community.repo /etc/yum.repos.d/mysql-community-source.repo
   
6. wget http://github.itzmx.com/1265578519/repo/master/CentOS/5.7/mysql-community.repo -O /etc/yum.repos.d/mysql-community.repo
   
7. yum -y install mysql mysql-server
   
8. yum -y install php-cli php-mysql  php-gd php-xml php-ldap php-mbstring php-bcmath php-pdo
   
9. service mysqld restart
   
10. chkconfig --level 2345 mysqld on
    
11. rm -rf /etc/my.cnf
    
12. wget http://github.itzmx.com/1265578519/kangle/master/mysql/5.7/my.cnf -O /etc/my.cnf
    
13. service mysqld restart

复制代码

根据这个贴，手动设置一次新密码（如果已经安装5.6并且初始化则不需要重新设置新密码，原有的密码就可以登录啦，但是已经3312初始化在进行5.7安装的话，会导致无法建立新的用户数据库，参考顶部解决方案）
https://bbs.itzmx.com/thread-95491-1-1.html

升级完毕后登陆ip:3312/admin后台，新建用户网站后，使用root账号登陆数据库管理，观察用户是否成功新建，若未成功建立，请看帖子顶部标红处解决方法

5.7优化/etc/my.cnf

1. # For advice on how to change settings please see
   
2. # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
   
3. 
   
4. [mysqld]
   
5. #
   
6. # Remove leading # and set to the amount of RAM for the most important data
   
7. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
   
8. innodb_buffer_pool_size = 8M
   
9. #
   
10. # Remove leading # to turn on a very important data integrity option: logging
    
11. # changes to the binary log between backups.
    
12. # log_bin
    
13. #
    
14. # Remove leading # to set options mainly useful for reporting servers.
    
15. # The server defaults are faster for transactions and fast SELECTs.
    
16. # Adjust sizes as needed, experiment to find the optimal values.
    
17. join_buffer_size = 8M
    
18. sort_buffer_size = 2M
    
19. read_rnd_buffer_size = 2M
    
20. datadir=/var/lib/mysql
    
21. socket=/var/lib/mysql/mysql.sock
    
22. server-id = 1
    
23. log-bin
    
24. max_binlog_size=50M
    
25. expire_logs_days=7
    
26. skip-networking
    
27. default-time-zone = '+8:00'
    
28. performance_schema_max_table_instances=200
    
29. table_definition_cache=200
    
30. table_open_cache=128
    
31. 
    
32. # Disabling symbolic-links is recommended to prevent assorted security risks
    
33. symbolic-links=0
    
34. 
    
35. log-error=/var/log/mysqld.log
    
36. pid-file=/var/run/mysqld/mysqld.pid

复制代码

注：5.6的和5.7的my.cnf不通用，开启log-bin一定要设置server-id，my.cnf优化启动内存到117MB（https://bbs.itzmx.com/thread-95490-1-1.html）


如需转载，请注明出处：IT技术交流论坛

不可名

太长看不懂

phrnet

支持 期待好久了

chungbin

新建网站不会自动创建数据库

chungbin

手动创建完数据库后在mysql库你的user表复制插入提示
#1364 - Field 'ssl_cipher' doesn't have a default value