CentOS安装MySQL

1.创建mysql数据存储目录
2.获取mysql资源
3.安装
4.配置
5.迁移
6.启动mysql-设置开机自启
7.初始化配置
8.测试mysql

---

1.创建mysql数据存储目录

mkdir -p /test/mysql/data

2.获取mysql资源

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

3.安装

yum -y install mysql-community-server

4.配置

vi /etc/my.cnf
datadir=/test/mysql
chown mysql:mysql /test/mysql

5.迁移

semanage fcontext -a -t mysqld_db_t "/test/mysql(/.*)?"
restorecon -Rv /test/mysql

6.启动mysql-设置开机自启

systemctl start mysqld
systemctl enable mysqld

7.初始化配置

mysql_secure_installation 按一次回车,输入密码
Remove anonymous users?	Y
Disallow root login remotely? N
Remove test database and access to it? Y
Reload privilege tables now? Y

8.测试mysql

mysql -uroot -p

完成。。。

---

常用语句
创建名称为【school】数据库

create database school;

创建zhangsan用户，权限只能访问【school】数据库

grant all privileges on school.* to zhangsan@'%' identified by '123456';
flush privileges;

执行sql文件

mysql -uzhangsan -p 【数据库名】 < 【sql文件路径】
mysql -uzhangsan -p school < /root/school.sql