每日一词——Linux + Mysql

安装 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