• Home
  • Systems
  • Networking
  • WordPress
  • Web
  • Geekery

Analysis and Review

How to Upgrade To mySQL 5.7 on Ubuntu 14

March 17, 2016 by Kurt Turner


Ubuntu 14.04 LTS
doesn’t allow for MySQL 5.7 via the base repository. You must tell apt-get where to grab the latest version of MySQL. Here’s a cheat sheet on what to do and the order you need to do it in. But before I get into how I upgraded MySQL on my Ubuntu server, I’m going to tell you why I needed 5.7. MySQL 5.7 has some new triggers I’d like to use for logging CRUD, good enough reason right? Anyways, the upgrade went smooth and we only had a couple issues to resolve which I show you how to resolve in the list below. Good luck!

 

  1. Download the MySQL release package from here – http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
  2. sudo dpkg -i mysql-apt-config_0.6.0-1_all.deb
  3. ubuntu-logosudo apt-get update
  4. sudo apt-get install mysql-server
  5. sudo mysql_upgrade -u root -p
  6. sudo service mysql status
  7. change /etc/passwd  (this will fix an error when restarting mysql)
    from
    mysql:x:106:110:MySQL Server,,,:/nonexistent:/bin/false
    to
    mysql:x:106:110:MySQL Server,,,:/var/lib/mysql:/bin/false
  8. remove “bind-address” from my.cnf  (relevent for local installations, may not apply in your situation)
  9. Service mysql stop and then start

Filed Under: Systems Tagged With: how to, mySQL, ubuntu, upgrade

Latest and Greatest

Apache vs Nginx for WordPress

Certbot Lets Encrypt And WordPress MU Multi-Site

How To Find and Replace Multiple File in MS Word

How To Get Stretch Res on Windows 10 AMD Radeon For Game Play

This is the ASUS Chromebox we've been running for 2 years as our "brain" for our home grown digital display kiosk.

DIY Digital Signage Bulletin Board or Kiosk

© Copyright Analysis And Review · All Rights Reserved ·