Install and configure MySQL on centos 7 and configure mysql on centos 7
1. Download MySQL Yum RepositoryHttp://dev.mysql.com/downloads/repo/yum/2. Install MySQL Yum Repository locallySudo yum localinstall platform-and-version-specific-package-name.rpm3. Install MySQLSudo yum-y install mysql-community-server4. view the root initial passwordSudo grep 'temporary password'/var/log/mysqld. log5. Perform Security SettingsMysql_secure_installation6. Set character setsVi/etc/my. cnf [mysql] default-character-set = utf8 [mysqld] character_set_server = utf87. Set startupChkconfig -- levels 235 mysqld on8. Disable CentOS FirewallFirewall-cmd -- permanent -- zone = public -- add-port = 3306/tcpfirewall-cmd -- permanent -- zone = public -- add-port = 3306/udpfirewall-cmd -- reload9. Create a remote access userCreate user 'bounter '@' % 'identified by '2017 @ bounter'; grant select, INSERT, UPDATE, delete on *. * TO 'bounter '@' % '; flush privileges;10. Start and close the MySQL ServiceSudo service mysqld startsudo service mysqld stop