How To Upgrade MySQL to 5.7 on CentOS/AWS Linux
erics, Posted December 7th, 2017 at 10:28:05am
START: Server version: 5.5.54-log MySQL Community Server (GPL)
FINISH: Server version: 5.7.20-log MySQL Community Server (GPL)
|
1 2 3 4 5 6 7 |
mysql --execute="SET GLOBAL innodb_fast_shutdown=0;" service mysqld stop yum remove mysql mysql-* yum install mysql57-devel mysql57-server mysql57-test service mysqld start mysql_upgrade service mysqld restart |
If you do not restart MySQL server at the end, you will get this error:
|
1 |
ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure |
Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:
|
1 |
Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed |
Categories: How-To's, Technology 5.5, 5.7, AWS, AWS Linux, CentOS, howto, mysql, MySQL 5.5, MySQL 5.7, tips, upgrade
Leave Your Comment
All fields marked with "*" are required.