Drip Cloud Install MySQL database

There's nothing to say, just a straight face.

Installing the MySQL Database

A) Download 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, the MySQL source installation is complete

c) Check whether the installation is complete: Yum Repolist enabled | grep "Mysql.*-community.*"

　　

d) Installing Mysql:yum install Mysql-community-server

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

e) set start MySQL service: Systemctl enable mysqld

f) View the installed MySQL version: Rpm-aq | Grep-i MySQL

　　　　

g) Start MySQL service: systemctl restart Mysqld

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

　　　　

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

　　　　

There is a problem changing the password here, the change failed because the password is too simple. There are two answer solutions:

Method One: Set the password to a complex point (this is the most straightforward method)

Method Two: Turn off MySQL password strength verification (Validate_password)

Edit Config file: vim/etc/my.cnf, add this line Validate_password=off

Restart MySQL service after editing: Systemctl restart Mysqld

j) Set MySQL to be able to access remotely:

Login into mysql:mysql-uroot-p password

Add a user grant access: Grant all privileges on * * to ' root ' @ ' IP address ' identified by ' password ' with GRANT option; You can change the IP to a percent of

　　　　

OK, I'll try the local connection.

　　　　

Well, it's over here, and I wish you all the bugs.

I qq:184370986

Drip Cloud Install MySQL database