Centos7 installs mysql Community Edition
Centos7 installs mysql Community Edition 1. Visit https://dev.mysql.com/downloads/repo/yum/ to get mysql yum sourcewget wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm2. Install mysql80-community yum sourcesudo yum localinstall mysql80-community-release-el7-3.noarch.rpm3. Use yum to install mysql-server installation version 80, cut version, please visit https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/sudo yum install mysql-server-y4. Start the mysql server service sudo systemctl start mysqld5. Check the mysql service sudo systemctl status mysqld6. Enable mysql self-boot sudo systemctl enable mysqld7. For the first time or reinstallation, please find the temporary password sudo grep 'temporary password' / var/log/mysqld.log8. Run the security script, enter the temporary password, and change the password to 1qaz@WSXsudo mysql_secure_installation9. Version check mysqladmin-u root-p version10. Create user and library mysql-u root-p
Create a library
Mysql > create database testdb
Create a user
Mysql > create user test IDENTIFIED by 'zxc123'
Authorize to the user
Mysql > GRANT ALL PRIVILEGES ON testdb.* TO test@'%'
Check user permissions
Mysql > use mysql;mysql > select user,host from user
Update permissions
Mysql > FLUSH PRIVILEGES
Quit
Mysql >\ Q11. Modify / etc/my.cnf bindaddr = 0.0.0.012. Restart mysqlsudo systemctl restart mysql