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…
Visit the download page and look for Ubuntu / Debian (Architecture Independent), DEB Package. Then click the Download button to get the repository package…
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.
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.
Also, you confirm whether you want to use the new password encryption feature… it’s recommended.
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: