___________________________________________________
| |
| |
| |
| |
| MySQL 5.6 for CentOS 7.3 |
| |
| Ver 1.1 |
| |
| 广东创恒科技发展有限公司 |
| |
| JackSong |
| 2017-9-20 |
|___________________________________________________|
一、系统安装
1、安装系统软件版
CentOS Linux release 7.3.1611 (Core)
2、安装系统
安装选最小安装
3. MYSQL版本
MySQL-5.6.34-1.el7.x86_64.rpm-bundle.tar
二、系统基本配置
1、关闭SELinux、防火墙
# systemctl stop firewalld
# systemctl disable firewalld
2、配置SELINUX
sed -i '/SELINUX/s/enforcing/disabled/' /etc/selinux/config
或者编辑 vi /etc/selinux/config
把SELINUX=enforcing
改为: SELINUX=disabled
重启电脑 或者 用命令立刻生效:
# reboot
# getenforce
3、配置IP地址
主机名:mysqldb1
eth0: 192.168.18.21 255.255.255.0 网关:192.168.18.254
4、配置/etc/hosts
vi /etc/hosts
192.168.18.21 mysqldb1
5、编辑安装源
建产mount点目录
mkdir /media/cdrom
mount 系统光盘
mount /dev/sr0 /media/cdrom
编辑安装源
vi /etc/yum.repos.d/local.repo
echo "[oscent73]
name=oscent73
baseurl=file:///media/cdrom
gpgcheck=0" >> /etc/yum.repos.d/local.repo
三、安装MYSQL
1、检查系统是否有mariadb,有就删除,因为mariadb与mysql有冲突。
rpm -qa | grep mariadb
(# yum -y remove mariadb-libs-5.5.52-1.el7.x86_64 删除旧版现安装)
2、将原配置文件删除或改名
# mv /etc/my.cnf /etc/my.cnf.old
3、安装依赖
yum install -y perl-Module-*
4、用SFTP上传安装安装包到服务器上
sftp> cd /tmp
sftp> put MySQL-5.6.34-1.el7.x86_64.rpm-bundle.tar
5、解压
# cd /tmp
# tar -xvf MySQL-5.6.34-1.el7.x86_64.rpm-bundle.tar
6、安装
# cd /tmp
# yum install *.rpm -y
7、复制配置文件
# cp /usr/share/mysql/my-default.cnf /etc/my.cnf
8、检查是否安装了软件包
# rpm -qa | grep MySQL
9、查看root密码
# cat /root/.mysql_secret
# The random password set for the root user at Thu Sep 21 09:46:16 2017 (local time): Y7kZfv3GoFYIJXhg (Y7kZfv3GoFYIJXhg是密码)
四、MySQL服务状态
1、查看MySQL服务
# systemctl status mysql
2、启动MySQL服务
# systemctl start mysql
3、重启MySQL服务
# systemctl restart mysql
4、查看MySQL服务端口
# netstat -lntup|grep mysql
5、停止MySQL服务
# systemctl stop mysql
6、设置自启动
#chkconfig mysql on
五、初始化MySQL密码
# service mysql start
# cat /root/.mysql_secret #查看root账号密码
# The random password set for the root user at Thu Sep 21 09:46:16 2017 (local time): Y7kZfv3GoFYIJXhg (Y7kZfv3GoFYIJXhg是密码)
# mysql -uroot -pY7kZfv3GoFYIJXhg
mysql> SET PASSWORD = PASSWORD('passw0rd'); #设置密码为passw0rd
mysql> exit
# mysql -uroot -ppassw0rd
六、开启MySQL远程访问
mysql -uroot -ppassw0rd
use mysql;
update user set password=password('passw0rd') where user='root';
update user set host='%' where user='root' and host='localhost';
flush privileges;
exit
七、更改数据库数据存储目录
1、确认MySQL数据库存储目录
# mysql -uroot -ppassw0rd
mysql> show global variables like "%datadir%";
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)
mysql> exit
2、关闭MySQL服务
# service mysql stop
3、创建新的数据库存储目录
# mkdir /mysqldata
4、移动MySQL数据目录到新位置
# mv /var/lib/mysql /mysqldata
5、修改配置文件my.cnf
# vi /etc/my.cnf
[client]
datadir = /mysqldata/mysql
socket = /mysqldata/mysql/mysql.sock
[mysql]
socket = /mysqldata/mysql/mysql.sock
6、修改启动脚本/etc/init.d/mysql
# vi /etc/init.d/mysql
datadir=/mysqldata/mysql/
7、启动MySQL服务并验证MySQL数据库路径
# service mysql start
mysql> show global variables like "%datadir%";
+---------------+-------------------+
| Variable_name | Value |
+---------------+-------------------+
| datadir | /mysqldata/mysql/ |
+---------------+-------------------+
1 row in set (0.00 sec)