1.卸载 先停掉mysql进程 没有安装过的可以直接跳过

pkill -9 mysqld

rpm -qa|grep -i mysql

用命令 yum -y remove

yum -y remove mysql-community-client-5.6.38-2.el7.x86_64

卸载不掉的用 rpm -ev

依次卸载 直到没有

2.下载mysql的repo源 这个安装的mysql5.7.20

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

yum -y install mysql-server

默认配置文件路径:

配置文件:/etc/my.cnf

日志文件:/var/log/var/log/mysqld.log

服务启动脚本:/usr/lib/systemd/system/mysqld.service

socket文件:/var/run/mysqld/mysqld.pid

3.配置 my.cnf vim /etc/my.cnf

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

server_id = 1

expire_logs_days = 3


# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0


log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid


#简化密码用

validate_password=off

default_password_lifetime=0

4. 启动mysql服务

service mysqld restart

查看密码

grep "password" /var/log/mysqld.log

修改密码并设置远程访问

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;


flush privileges;