Centos: config mysql server

From cslt Wiki
Revision as of 09:52, 1 November 2016 by Wangyang (Talk | contribs)

Jump to: navigation, search

1. install mysql server on centos

a) wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
b) sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
c) yum install mysql-community-server
d) service mysqld restart

2. set password for 'root'

a) # mysql -u root
b) mysql> use mysql;
c) mysql> update user set password=PASSWORD(‘your_password’) where User='root';

3. add new user

a) mysql> select host,user from user;

5. allow firewall accept port 3306

a) # firewall-cmd --add-service=mysql --permanent
b) # firewall-cmd --reload
c) iptables -L -n | grep 3306 (check whether port 3306 is accept)
    ACCEPT     tcp  --              tcp dpt:3306 ctstate NEW
d) firewall-cmd --state (check the state of the firewall)

6. try to access mysql from remote host

a) mysql -h "xxx.xxx.xxx.xxx" -u username -p