MySQL website download rpm package, I choose the latest version of MySQL 8.0
Install RPM Package:rpm -uvh platform-and-version-specific-package-name. RPM
Download MySQL:yum install mysql-server (Note this is-server)
Start Services after installation: Servicemysqld start
To view the status of the database service: service mysqld status
After MySQL installation, there will be a default username root and a temporary password, to view this password can:
grep ' temporary password '/var/log/mysqld. Log
You can then log into the database with the user password that comes with it:
After that, if you are going to use the host's navicat to connect to this database, you will be prompted a series of errors, which is normal.
1.1130 error, this error is because the default user only allows the host to log into the database, to the default root user ' localhost ' to the '% '
create user ' root ' @ '% ' identified by ' xxxxxxxx ';
2.2059 error, this error is the version reason for MySQL.
One solution is to update the driver, this is not researched, and the other is to use the old encryption method to authenticate the user:
ALTER USER ' root ' @ '% ' identified with Mysql_native_password by ' xxxxxxxx ';
Reference: https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-installing
Linux installation MySQL Database