Linux CentOS MySQL database installation and configuration tutorial

Notes on installing MySQL database, share with everyone

a) Download the MySQL source installation package: wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

b) Install MySQL source: yum localinstall mysql57-community-release-el7-8.noarch.rpm

If complete! appears at the end, it means that the MySQL source installation is complete.

c) Check whether the installation is complete: yum repolist enabled | grep "mysql.*-community.*"

d) Install mysql: yum install mysql-community-server

If Complete! appears at the end, the MySQL installation is complete.

e) Set to start the mysql service: systemctl enable mysqld

f) Check the installed MySQL version: rpm -aq | grep -i mysql

g) Start the MySQL service: systemctl restart mysqld

h) View the initial MySQL password: grep 'A temporary password' /var/log/mysqld.log

i) Change MySQL password: mysqladmin -u root -p 'old password' password 'new password'

There is a problem with changing the password here and the change fails because the password is too simple. There are two solutions:

Method 1: Make your password more complex (this is the most direct method)

Method 2: Turn off MySQL password strength verification (validate_password)

Edit the configuration file: vim /etc/my.cnf , add a line validate_password=off

After editing, restart the mysql service: systemctl restart mysqld

j) Set up mysql to be accessible remotely:

Log in to MySQL: mysql -uroot -p password

Add a user to grant access rights: grant all privileges on *.* to 'root'@'ip address' identified by 'password' with grant option; //You can change the ip to %%, which means all privileges are enabled

OK, I will try the local connection.

Okay, that’s the end. I hope you don’t encounter any bugs.

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.