Get the App
SLTechnology News&Howtos  ›  Database  › 

Centos7 installs mysql Community Edition

Shulou Source: shulou.com Published: 2022-06-01 08:24:07 11月20日 Update

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

Tags: Users passwords versions checks permissions services communities security scripts updates input run Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux Apple OPPO Reno Microsoft Shulou Technology