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

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

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.