CentOS 7.0 Installation MySQL

1. Download the MySQL repo source
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2. Install the MYSQL-COMMUNITY-RELEASE-EL7-5.NOARCH.RPM package
RPM-IVH mysql-community-release-el7-5.noarch.rpm
After installing this package, you will get two MySQL yum repo Source:/etc/yum.repos.d/mysql-community.repo,/etc/yum.repos.d/mysql-community-source.repo.
3. Install MySQL
sudo yum install Mysql-server
Follow the steps to install it, but after the installation is complete, there is no password and you need to reset the password.
4. Reset Password
Before resetting your password, you must first log in
Mysql-u Root
This error may be reported at login: Error 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2) because/var /lib/mysql access rights issues. The following command changes the owner of the/var/lib/mysql to the current user:
Chown-r Root:root/var/lib/mysql
Then, restart the service:
Service mysqld Restart
Next login to reset Password:

Mysql-u Root
Use MySQL;
Update user set Password=password (' 123456 ') where user= ' root ';
Flush privileges;

5. Open 3306 Ports
Vim/etc/sysconfig/iptables
Add the following content:
-A input-p tcp-m state--state new-m TCP--dport 3306-j ACCEPT
Restart the firewall after saving:
Systemctl Restart Firewalld.service
This allows the MySQL service to be connected from other clients as well.

CentOS 7.0 Installation MySQL