ubuntu 14.04 mysql 版本升级 5.5到5.7

[kagxin]

• 备份所有数据数据，如果需要的话

  mysqldump -uroot -p'password' --all-databases > all_databases.sql

• 下载mysql 最新的 mysql apt repository

  wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb

• 安装apt repo

  sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

  

• 更新源

  sudo apt-get update

• 安装mysqlserver

  sudo apt-get install mysql-server

• 升级一下数据库文件版本

  sudo mysql_upgrade -u root -p'password' 

• 重启msyql

  sudo service mysql restart

• 并检查一下数据是否正常

  mysqlcheck -uroot -p'password' --all-databases

ref ： https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ https://askubuntu.com/questions/750498/mysql-5-5-update-to-mysql-5-7 https://www.typechodev.com/case/754.html https://askubuntu.com/questions/148383/how-to-resolve-dpkg-error-processing-var-cache-apt-archives-python-apport-2-0/266912

[kagxin]

最新 mysql apt repo，查看地址： https://dev.mysql.com/downloads/repo/apt/

[kagxin]

如果出现 Table 'performance_schema.session_variables' doesn't exist的问题就执行

• mysql_upgrade -u root -p --force
• systemctl restart mysqld

ref ： https://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist

[kagxin]

如果ubuntu版本为 Ubuntu 12.04.5 LTS，mysql的repo可以使用

http://dev.mysql.com/get/mysql-apt-config_0.7.2-1_all.deb

[kagxin]

安装中断补救

sudo apt-get install --reinstall pkg-name sudo dpkg --configure -a 如果出现： dpkg: error processing mysql-apt-config (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mysql-apt-config

sudo rm /var/cache/debconf/*.dat

[kagxin]

https://askubuntu.com/questions/441047/dpkg-deb-error-subprocess-paste-was-killed-by-signal-broken-pipe-nginx

[kagxin]

ubunut 12.04 mysql 5.5 升级到5.6

ref : https://askubuntu.com/questions/690855/mysql-5-6-dpkg-install-error-even-after-complete-uninstall

卸载mysql

sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean