环境配置-mysql安装

1.安装mysql

sudo yum  -y install mysql-server

2.修改字符集

sudo vim /etc/my.conf添加：default-character-set=utf8

3。设置随机启动

sudo chkconfig mysqld on

查看是否设置成功

4.启动mysql

sudo server msyql start

5.登录mysql

mysql -u root

6.查看mysql用户

select user , host from mysql.user;

7.删除匿名用户

select user , host from mysql.user;

8.防火墙设置

sudo vim /etc/sysconfig/iptables

添加：

9.重启防火墙

sudo service iptables restart

10.查看用户权限

 select * from mysql.user /G

11.权限设置
grant select ,delete, create on mall.* to mall@’%’ identified by ‘mall’ with grant option;

12.设root密码

set password from root@localhost='123';set password for root@127.0.01=password('123');