1.环境准备
服务器:Red Hat 6.5 64位
数据库:MySQL 5.7
2.下载MySQL
下载地址:https://dev.mysql.com/downloads/mysql/5.7.html#downloads
如图所示:
下载RPM Bundle完整包mysql-5.7.26-1.el6.x86_64.rpm-bundle.tar
3.安装MySQL
3.1 检查是否已经安装MySQL
rpm -qa|grep mysql #查看是否已经安装MySQL
rpm -e --nodeps mysql-libs* #删除已经安装的MySQL
注:centos7安装时需要检查mariadb
3.2 解压下载的安装包
tar -xf mysql-5.7.26-1.el6.x86_64.rpm-bundle.tar
如图所示:
3.3 依次安装依赖包
rpm -ivh mysql-community-common-5.7.26-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el6.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.26-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el6.x86_64.rpm
至此已经安装成功
3.4 修改配置文件my.cnf
vim /etc/my.cnf
#添加内容如下,设置数据库及客户端的字符集和校对:
[mysql]
default-character-set=utf8mb4
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_bin
#保存并退出
3.5 初始化MySQL服务器
mysqld_safe --initialize
3.6 启动MySQL服务器
service mysqld start #启动服务
service mysqld stop #停止服务
service mysqld restart #重启服务
service mysqld status #查看启动状态
3.7 查看MySQL登录密码
cat /var/log/mysqld.log|grep password #该密码为临时密码
3.7 登录MySQL服务器,密码为临时密码
mysql -uroot -p
3.8 修改临时密码
set password=password('123456789'); --重置root密码
flush privileges; --刷新权限
3.9 设置远程访问
grant all privileges on *.* to ‘root’@’%’ identified by ‘123456789’ with grant option; --授权
flush privileges; --刷新权限
3.10 创建非root用户
create user 'paul'@'%' identified by '123456789'; --创建用户paul
grant all privileges on *.* to ‘paul’@’%’ identified by ‘123456789’ with grant option; --授权
flush privileges; --刷新权限
3.11 设置开机启动
chkconfig mysqld on
chkconfig --list mysqld #查看开启状态