安装 MySQL
sudo yum -y install mysql-server
配置MySQL
字符编码
vim /etc/my.cnf
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
collation_server=utf8_general_ci
开机自启
chkconfig mysqld on
chkconfig –list mysqld
启动mysql
sudo service mysqld restart
删除空用户
delete from mysql.user where user=”;
设置密码
set
创建新用户
insert into mysql.user(host, name, password) values(‘gene’, password(‘123’), localhost);
grant all priviliges on file_sys.* to gene@’%’ identified by ‘123’ with grant option;
防火墙端口开放(如果是阿里云服务器,编辑安全组规则)
sudo vim /etc/sysconfig/iptables
-A INPUT -p tcp -m stat –state NEW -m tcp –dport 3306 -j ACCEPT
sudo service iptables restart