Install and configure mysql on CentOS7

Install and configure mysql on CentOS7
Installation 1. The default software source for CentOS7 does not contain mysql. You must first add the mysql repo source.

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

2. Use rpm to install the software package just downloaded

rpm -ivh mysql-community-release-el7-5.noarch.rpm

3. Install yum

yum install mysql-server

4. Start mysql

systemctl start mysql

Configuration 1. Modify the root password

mysqladmin -u root password "newpassword"

2. Local Login

   mysql -u root -p

If an error occurs

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Please refer to [solution] ERROR 2002 (HY000): Can't connect to local MySQL server

3. Add a remote user

GRANT ALL PRIVILEGES ON *.* for 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;FLUSH PRIVILEGES;

4. Open Port 3306

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT