Detailed steps to install MYSQL8.0 on CentOS7.6

1. Generally, mariadb is installed by default in CentOS, so first check whether mariadb is installed. If it is installed, you need to uninstall mariadb first.

rpm -qa|grep mariadb
rpm -e mariadb-libs --nodeps 

2. Create a mysql folder in the /usr/local/directory

cd /cd usr/localmkdir mysql 

3. Enter the mysql folder and download mysql

cd mysqlwget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar 

4. Unzip mysql to the current directory

tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar 

5. Install mysql and execute the following commands in sequence

rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm --nodeps --forcerpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm --nodeps --forcerpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm --nodeps --forcerpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm --nodeps --force 

6. Initialization and related configuration, execute the following commands in sequence

mysqld --initialize; chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;systemctl enable mysqld;

If the following error message appears when executing mysqld --initialize;, first execute yum -y install numactl, and then execute mysqld --initialize;

If the following error message appears when executing systemctl start mysqld.service;, first execute tail -f /var/log/mysqld.log to view the error log

If the error log is as follows, run cd /var/lib/mysql, run rm -rf * to delete all files, and then run systemctl start mysqld.service;

7. View the database initialization password

cat /var/log/mysqld.log | grep password 

8. Log in to the database, copy and paste the initial password, the login password will not be displayed, press Enter

mysql -uroot -p 

9. Change password. Password needs numbers, uppercase and lowercase letters, and special symbols.

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxxxx'; 

10. Exit MySQL, then log in again with the new password to verify whether the password has been changed successfully

exit;mysql -uroot -p 

11. Create a remote access user and execute the following commands in sequence

create user 'root'@'%' identified with mysql_native_password by 'xxxxx';grant all privileges on *.* to 'root'@'%' with grant option;flush privileges;

12. Generally, the server does not have port 3306 developed by default. You need to configure the security group in the server console.

Summarize

The above is the detailed steps for installing MYSQL8.0 on CentOS7.6 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!