How To Upgrade MySQL to 8.0 on CentOS/AWS Linux
erics, Posted August 31st, 2023 at 11:02:51am
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 |
Categories: How-To's, Technology 5.7, 8.0, AWS, AWS Linux, CentOS, howto, mysql, MySQL 5.7, MySQL 8.0, tips, upgrade
Leave Your Comment
All fields marked with "*" are required.