CentOS7安装Mysql5.7

726 阅读1分钟

1、查看是否安装mariadb,有删除

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64

2、安装依赖

yum -y install numactl.x86_64

3、解压

tar -zxvf mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz

4、创建数据目录

cd /usr/java/mysql-5.7.10-linux-glibc2.5-x86_64
mkdir data

5、创建系统用户组和用户

cat /etc/group # 查看用户组信息
groupadd mysql
cat /etc/passwd | grep mysql # 查看是否存在mysql用户
useradd -g mysql mysql

6、将当前目录授权给mysql

chown -R mysql:mysql /usr/java/mysql-5.7.10-linux-glibc2.5-x86_64

7、初始化数据库

cd /usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/bin
./mysqld --initialize --user=mysql --basedir=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64 --datadir=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/data

注意结尾是root初始秘密:tN=kuLp9!k.x

8、MySQL加入服务

cp /usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/support-files/mysql.server /etc/init.d/mysql

修改配置

vi /etc/init.d/mysql

修改内容:

basedir=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64
datadir=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/data

9、配置my.cnf

vi /etc/my.cnf

编辑内容:

[client]
port=3306
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
character_set_server=utf8mb4
init_connect='SET NAMES utf8mb4'
basedir=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64
datadir=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/data
socket=/tmp/mysql.sock
#不区分大小写 
lower_case_table_names = 1
#不开启sql严格模式
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
log-error=/var/log/mysqld.log
pid-file=/usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/data/mysqld.pid

10、启动mysql

service mysql start
service mysql stop

11、修改默认密码,创建远程连接用户

cd /usr/java/mysql-5.7.10-linux-glibc2.5-x86_64/bin
./mysql -uroot -p

输入初始密码,连接成功后执行:

set password='123abc';
flush privileges; ---刷新权限,之后退出重新登录
create user root@'%' identified by '123abc';
grant all privileges on *.* to root@'%' with grant option;
flush privileges;

12、设置开机启动

chkconfig --add mysql
chkconfig mysql on
chkconfig --list # 查看

3、4、5是开或on说明成功,如果是关或off执行:

chkconfig --level 345 mysql on