How To Upgrade MySQL to 8.0 on CentOS/AWS Linux
START: Server version: 5.7.43-log MySQL Community Server (GPL) FINISH: Server version: 8.0.34-log MySQL Community Server (GPL)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql --execute="SET GLOBAL innodb_fast_shutdown=0;" service mysqld stop yum remove mysql mysql-* mysql57-community-release yum install https://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm yum update yum install mysql-community-server cp /etc/my.cnf.rpmsave /etc/my.cnf service mysqld start grep 'temporary password' /var/log/mysqld.log | tail -1 mysql -p Enter password: ALTER USER 'root'@'localhost' IDENTIFIED BY 'newRootPassword'; |
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html 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 |