Programster's Blog

Tutorials focusing on Linux, programming, and open-source

Ubuntu 14.04 - Install MySQL 5.7

Now that MySQL 5.7 is available, you may want to read about what's new and execute the script below to install it on Ubuntu 14.04. This will result in installing version 5.7.11 at the time of writing this tutorial.

This will add the MySQL PPA so that you should receive updates through normal apt-updates rather than having to manually download deb packages.

cd /tmp

# Confirm the version at
wget -O mysql-apt-config.deb

sudo dpkg -i mysql-apt-config.deb

# At the popup-page, select "Apply"

# Install mysql-server package
sudo apt-get update
sudo apt-get install mysql-server-5.7 -y

## References

Mid way through the installation, you will be given the following screen at which you need to just select "Apply".

Default Configuration

For reference, the default configuration file at /etc/mysql/my.cnf is as follows:

# Copyright (c) 2014, 2015, Oracle and/or its affiliates. All rights reserved.
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

# The MySQL Community Server configuration file.
# For explanations see

port            = 3306
socket          = /var/run/mysqld/mysqld.sock

pid-file        = /var/run/mysqld/
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

user            = mysql
pid-file        = /var/run/mysqld/
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address    =

log-error       = /var/log/mysql/error.log

# Disabling symbolic-links is recommended to prevent assorted security risks

# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
!includedir /etc/mysql/conf.d/
Last updated: 25th January 2021
First published: 16th August 2018