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.
#!/bin/bash
cd /tmp
# Confirm the version at http://dev.mysql.com/downloads/repo/apt/
wget -O mysql-apt-config.deb https://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.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
* http://www.devopsservice.com/installation-of-mysql-server-5-7-on-ubuntu-14-04/
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
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# 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
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
log-error = /var/log/mysql/error.log
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# * 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
First published: 16th August 2018