Tutorial analysis of quick installation of mysql5.7 based on centos7

one.

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

two.

yum -y localinstall mysql57-community-release-el7-11.noarch.rpm

three.

yum -y install mysql-community-server

Four.

systemctl start mysqld<br>ps -ef | grep mysql

5.MySQL default password

cat /var/log/mysqld.log

Login

mysql -uroot -pykO:DNGXx5ee

7. Change the default password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Qwe340721@';

Set up remote login

RANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Qwe340721@' WITH GRANT OPTION;

quit

exit;

8. Open port 3306 on the firewall

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

9. Configure MySQL default encoding to utf-8

vim /etc/my.cnf<br><br>

character_set_server=utf8

init_connect='SET NAMES utf8'

10. Restart the service

systemctl restart mysqld

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.