CentOS 7.5安装MySQL 5.7教程 免安装版

2019独角兽企业重金招聘Python工程师标准>>>

1.环境准备

服务器：CentOS 7.5 64位

数据库：MySQL 5.7

2.下载MySQL

下载地址：https://dev.mysql.com/downloads/mysql/5.7.html#downloads

安装包：mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

3.安装MySQL

3.1 检查是否已经安装MySQL/MariaDB

rpm -qa|grep mysql #查看是否已经安装MySQL
rpm -e --nodeps mysql* #删除已经安装的MySQL
rpm -qa|grep mariadb #查看是否已经安装MariaDB
rpm -e --nodeps mariadb* #删除已经安装的MariaDB

3.2 上传安装包

利用MobaXterm软件上传,保存路径： /usr/local/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

3.2 解压下载的安装包并移动到mysql文件夹中

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql

3.3 配置环境变量

vim /etc/profile

MYSQL_HOME=/usr/local/mysql
PATH=$MYSQL_HOME/bin:$PATH
EXPORT PATH

source /etc/profile #使得修改生效

3.4 创建配置文件my.cnf

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf

[mysql]
socket=/usr/local/mysql/mysql.sock
default-character-set=utf8mb4

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
# port=3306
# server_id=2
socket=/usr/local/mysql/mysql.sock

default_storage_engine=innodb
character-set-server=utf8mb4
collation-server=utf8mb4_bin
lower_case_table_names=1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/usr/local/mysql/data/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid

3.5 加入开机启动项

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
vim /etc/init.d/mysqld

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

3.6 创建mysql用户组和mysql用户

groupadd mysql
useradd -r -g mysql mysql

3.7 修改mysql相关文件的所有者为mysql

chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /etc/my.cnf
chown -R mysql:mysql /etc/init.d/mysqld

3.8 初始化MySQL服务器

/usr/local/mysql/bin/mysqld --initialize #记下生成的临时密码

3.9 启动MySQL服务器

service mysqld start #启动服务
service mysqld stop #停止服务
service mysqld restart #重启服务
service mysqld status #查看启动状态

3.10 登录MySQL

mysql -uroot -p #并输入临时密码

3.11 修改临时密码

set password=password('123456789'); #重置root密码
flush privileges; #刷新权限

3.12 设置远程访问

grant all privileges on *.* to 'root'@'%' identified by '123456789' with grant option; #授权
flush privileges; #刷新权限

3.13 开启3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl stop firewalld.service #重启防火墙
systemctl start firewalld.service

3.14 设置开机启动

chkconfig mysqld on
chkconfig --list mysqld #查看开启状态

3.15 创建非root用户

create user 'paul'@'%' identified by '123456789'; #创建用户paul
grant all privileges on *.* to 'paul'@'%' identified by '123456789' with grant option; #授权
flush privileges; #刷新权限

转载于:https://my.oschina.net/u/3005066/blog/3047716