Shulou(Shulou.com)06/01 Report--

Record the process of installing mysql under Centos

Lab environment: centos 7, mysql5.7 Community Edition

1. Download the mysql5.7 Community Edition installation package

2.centos directly unzipped and installed without any obstacles.

3. During installation, the initial password will be written to var/log/mysqld.log, open the file, find the password line and record it.

You can also find it directly with the grep command

4. Start mysql to see if the status has been started normally

5.mysql-uroot-p logs in with the initial password, and the default user is root@localhost

6.alter user 'root'@'localhost' identified by'; change the password, note that the password needs to meet the complexity requirements

7. Add new users or set root users to be remotely accessible

Grant all privileges on. To 'root' @'% 'identified by' 'with grant option

8. The firewall opens port 3306 so that other users can log in from elsewhere

Firewall-cmd-zone=public-add-ports=3306/tcp-permanent

Firewall-cmd-reload

Finally, the test shows that sqlyog login is correct and finished.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.