MySQL 8 use caching_sha2_password as the default authentication method. Many MySQL clients still do not support this method. If you need to use the old method, you can set the authentication plugin as mysql_native_password. You can also set this as the default method by editing my.cnf file. To change a user to use mysql_native_password, run
To Add MySQL yum repository to your server, go to https://dev.mysql.com/downloads/repo/yum/ Download the rpm file available. For RHEL/CentOS 7 wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm rpm -ivh mysql80-community-release-el7-3.noarch.rpm For RHEL/CentOS 6 wget https://dev.mysql.com/get/mysql80-community-release-el6-1.noarch.rpm rpm -ivh mysql80-community-release-el6-1.noarch.rpm Installing MySQL Server yum install mysql-community-server Stop/Start MySQL To stop/start MySQL, use service name “mysqld”. systemctl start mysqld systemctl stop mysqld systemctl restart … Read more
To install MySQL 8 on Ubuntu/Debian, download the .deb repository file from https://dev.mysql.com/downloads/repo/apt/ Following link may change, so always get newer version download link from above url. wget https://dev.mysql.com/get/mysql-apt-config_0.8.24-1_all.deb dpkg -i mysql-apt-config_0.8.24-1_all.deb It ask you to select MySQL version, default is 8, just press down arrow and select “Ok”. Now you are ready to install … Read more