linux安装mysql，只看这一篇就够了

检查是否装有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';