今天在卸载mysql5.5的时候,按照教程一步步操作,然后安装mysql5.7时,安装都没有任何问题,直到首次启动时报错,网上看了很多解决办法,都不适用,突然发现之前自己在用mysql5.5时,将/usr/share/mysql/my-huge.cnf复制到/etc下面了并重命名为my.cnf,修改了一些配置,mysql5.5.x卸载时好像不会自动删除/etc下的my.cnf文件,导致安装的mysql5.7没有生成自己的配置文件,使用的是之前5.5的配置文件,导致mysql服务启动时报错。
解决办法:
找一份由mysql5.7生成的配置文件替换/etc下的my.cnf。
手动删除/etc下的my.cnf,再将安装好的mysql5.7卸载重装,ok。
以下是我重新安装生成的my.cnf文件
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[client]
[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
# 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