mysql5.6升级到5.7
下载安装文件
到mysql官网找到5.7的下载地址:https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
//下载mysql压缩包
cd /usr/local/
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
//解压缩
tar -xvzf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
处理旧版mysql
//关闭mysql服务
service mysqld stop
//备份mysql5.6
mv /usr/local/mysql /usr/local/mysql5.6
安装mysql5.7
//修改目录名
mv /usr/local/mysql-5.7.33-linux-glibc2.12-x86_64 /usr/local/mysql
//创建data目录,mysql5.7.33默认没有这个文件
mkdir /usr/local/mysql/data
//安装mysql5.7
/usr/local/mysql/bin/mysqld --initalize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
安装完mysql,注意看最后一行root密码
//启动mysql
service mysqld start
修改密码
//登录mysql
mysql -uroot -ppwd
//修改密码
alter user 'root'@'localhost' identified by 'new passwd';
flush privileges;
自此mysql升级完成。