MySQL Server 8.0.14 Released — Here’s How to Install / Upgrade on Ubuntu 16.04 | 18.04

MySQL Server, the popular open source database server has been updated to the latest version (8.0.14), and this brief tutorial shows students and new users how to install or upgrade on Ubuntu 16.04 | 18.04 LTS servers…

This release brings lots of changes including, support for importing BSON data, a feature to disable innodb_buffer_pool_in_core_file to reduce its size, a full support for InnoDB parallel clustered index reads, which can improve CHECK TABLE performance, a bux fix for importing a dump from a MySQL 5.7 server to a server running MySQL 8.0 often failed and many more…

For more about this release, please check its release note..

Below is a list of some of the features and bug fixes included with this release:

  • Support for importing BSON data.
  • Ability to show column type information when executing SQL.
  • Addition of command line options to lower the verbosity when the shell starts.
  • Improved InnoDB Cluster support by enhancing the Admin API to support new features provided by Group Replication. For additional details look at MySQL InnoDB Cluster – What’s new in the 8.0.14 (GA) release.
  • Improved the Upgrade Checker utility to:
    • Support upgrades to MySQL 8.0.14.
    • Provide instructions on checks that can not be automated.
  • Enhanced the –socket connection option to use the default socket path when the option is used without a value.
  • Improved output formatting options. Now general shell output and SQL results use independent formatting options, for more details look at the Output Formats section in the User Guide.

To install the latest version MySQL follow steps below:

Step 1 Get MySQL APT Repository

The MySQL package version that comes with Ubuntu default repositories is not the latest version… If you need to install the latest version of MySQL database, you may want to install its repository in Ubuntu..

Go to the link below download the APT repository

The repository package for Ubuntu and others can be downloaded from the link below…

https://dev.mysql.com/downloads/repo/apt/

Visit the download page and look for Ubuntu / Debian (Architecture Independent), DEB Package. Then click the Download button to get the repository package…

ubuntu mysql repository

You can also use the command line to download.. changing the version number of the package.

cd /tmp/
wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb

Then run the commands below to install

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

When you run the commands above, you should get a config prompt.. just select OK as shown in the image below.

MySQL APT Repo features MySQL Server along with a variety of MySQL  components. You may select the appropriate product to choose the version that you wish to receive.

MySQL 8 on Ubuntu

Step 2: Install MySQL 8.0

Now that the repository is installed, run the commands below to install

sudo apt update
sudo apt install mysql-server mysql-client

That will install the latest version MySQL on your system… During the installation, you should be prompted to create and confirm a MySQL root password.

MySQL 8

Also, you confirm whether you want to use the new password encryption feature… it’s recommended.

MySQL 8 install ubuntu

After that, MySQL should be installed… you can logon by running the commands

sudo mysql -u root -p

You should see MySQL welcome screen shown below:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.14 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

That how to install the latest version of MySQL on Ubuntu..

You may also like the post below:

Setup Pydio File Sharing and Sync on Ubuntu 16.04 / 18.04 with Nginx, MariaDB and PHP 7.2-FPM

2 Replies to “MySQL Server 8.0.14 Released — Here’s How to Install / Upgrade on Ubuntu 16.04 | 18.04

  1. Why non using MySQL installer? It is the easiest way. MySQL installer provides you with an easy-to-use wizard that helps you to install MySQL. To download MySQL installer, go to the following link http://dev.mysql.com/downloads/installer/. There are two files are available. If you are connecting to the internet while installing MySQL, you can choose the online installation version mysql-installer-web-community.exe . If you want to install MySQL offline, you can download the mysql-installer-community.exe file.

  2. @CoolWriter, the article is about Ubuntu, where a .exe is worthless. The method provided in this article allows you to keep your packages up to date using familiar apt tools on Ubuntu, which is very nice.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.