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