MySQL 8.0.13 installation and configuration tutorial under CentOS7.3

1. Basic Environment

1. Operating system: CentOS 7.3
2. MySQL: 8.0.13 Link: https://pan.baidu.com/s/13-j_umr7eEnKFaugw4YTqQ Extraction code: 62yt

2. Install MySQL

1. Uninstall mariadb database

rpm -qa | grep mariadb
yum -y remove mariadb-libs-5.5.52-1.el7.x86_64

2. Install related dependencies (this article uses CentOS 7.3 image as local offline yum source)

yum -y install openssl-devel perl-JSON

3. Unzip and install MySQL

tar -xvf mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-*.rpm

4. Modify the configuration file

vim /etc/my.cnf

default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8
max_allowed_packet = 100M

5. Initialize the database and start

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

6. View the temporary password and modify the MySQL password using the temporary password

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

mysqladmin -uroot -pbga/.tkZw4q! password Test1212!

7. Grant remote user permissions

mysql -u root -p

create user 'root'@'%' identified with mysql_native_password by 'Test1212!';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;

8. Modify the password when logging in to localhost to prevent local login failure

mysql -uroot -p -h 192.168.0.101

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test1212!';

flush privileges;

9. Modify encryption rules

The encryption rules of MySql 8.0 and 5.0 are different, and the current visualization tool only supports the old encryption method. If it is not modified, the visualization tool may not be able to open the database.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;

flush privileges;

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.