检查是否装有mariadb
rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
卸载
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
1.上传mysql安装包到Linux目录
2.解压并重命名
tar -zxvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
3.创建mysql用户组和用户
4.创建data目录
5.更改目录用户
6.在/home/mysql-5.7.38/support-files创建文件my_default.cnf
vi my_default.cnf
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
basedir = /home/mysql-5.7.38
datadir = /home/mysql-5.7.38/data
port = 3306
socket = /tmp/mysql.sock
character-set-server=utf8
log-error = /home/mysql-5.7.38/data/mysqld.log
pid-file = /home/mysql-5.7.38/data/mysqld.pid
拷贝到/etc目录
cp my_default.cnf /etc/my.cnf
7.初始化mysql
cd /home/mysql-5.7.38
./bin/mysqld --initialize --user=mysql --basedir=/home/mysql-5.7.38/ --datadir=/home/mysql-5.7.38/data/ --defaults-file=/etc/my.cnf
查看临时密码
less /home/mysql-5.7.38/data/mysqld.log
将启动脚本放在开机初始化目录
cp support-files/mysql.server /etc/init.d/mysql
8.启动mysql
service mysql start
9.其他设置
cd /opt/mysql/mysql-5.7.25
./bin/mysql -u root -p
修改密码以及远程登录权限
set password=password('root');
grant all privileges on *.* to root@'%' identified by 'root';