需要提前准备好MySQL8.0.28的压缩包文件
- 1 查看当前mysql版本
- 2 停止当前运行的mysql
service mysqld stop
- 3 将下载好的压缩包导入(8.0.28),解压压缩包
sudo tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz -C /usr/local/
- 4 修改之前的文件名,将mysql改为mysqlold
sudo mv /usr/local/mysql/ /usr/local/mysqlold
- 5 修改新解压的文件名
sudo mv /usr/local/mysql-8.0.28-linux-glibc2.12-x86_64/ /usr/local/mysql
- 6 修改配置文件
sudo vi /etc/my.cnf
修改前: datadir=/usr/local/mysql/data
修改后: datadir=/usr/local/mysqlold/data
也可以不修改配置文件,进行data目录的拷贝
cp -r /usr/local/mysql8021/data /usr/local/mysql/data
sudo chmod -R 777 /usr/local/mysql/data/
cd /usr/local/mysql/data
chmod +777 ../* -R
chown -R mysql:mysql /usr/local/mysql/
chown -R mysql:mysql /usr/local/mysql/data/
- 7 拷贝启动文件到/etc/init.d/下并重命名为mysqld
sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
- 8 增加执行权限
sudo chmod 777 /etc/init.d/mysqld
- 9 删除之前的软连接
rm -rf /usr/bin/mysql
- 创建新的软连接
sudo ln -s /usr/local/mysql/bin/mysql /usr/bin
- 10 启动mysql服务
service mysql start
- 11登录数据库,查看版本
