Upgrading MySQL 5.7 to 8.0 in RHEL/CentOS 7
MySQL 8.0 was released couple day ago. MySQL 8.0 bring some new features and improvement. Here are the step to upgrade MySQL 5.7 to 8.0 Download the repository and install it rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm After that, do upgrade by typing yum update mysql-community-server --enablerepo=mysql80-community Wait until the update process finish. After that, type this command mysql_upgrade -u root -p<yourpassword> If you do not do that command, you would face this following error : The user specified as a definer ('mysql.infoschema'@'localhost') does not exist . Wait until the process finish. Done, your mysql is ready. PS : In this version, MySQL change the default authentication type to caching_sha2_password. this type of authentication is not supported yet for common driver like PHP mysqli. So, for the temporary solution, you could change the default authentication type t