Install Percona Server for MySQL on Ubuntu Linux

Computer monitor with security lock icon
Computer monitor with security lock icon

Percona Server for MySQL is a fork of the MySQL relational database management system created by Percona. It is a free, open-source replacement for MySQL community database server with enterprise features, stability, and support.

Percona MySQL server is a drop-in replacement for MySQL server. So, you can replace MySQL Server on your system, and applications that depend on MySQL won’t know the difference. However, if you want enterprise features with MySQL, you may want to try Percona.

For more about Percona for MySQL, please check its homepage.

This brief tutorial shows students and new users how to install Percona for MySQL server on Ubuntu 16.04 | 18.04To get Percona for MySQL installed, follow the steps below:

Add Percona MySQL Repository

To get the latest version of Percona for MySQL, you will want to add its repository to Ubuntu. To do that, run the commands below:

sudo apt update
sudo apt install wget
wget$(lsb_release -sc)_all.deb

After that, run the commands below to install the repository file

sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb

When you run the commands above, it will create a repository file in the default Ubuntu package repository folder. You should get a message below when done:

The percona-release package now contains a percona-release script that can enable additional repositories for our newer products.
For example, to enable the Percona Server 8.0 repository use:
  percona-release setup ps80
Note: To avoid conflicts with older product versions, the percona-release setup command may disable our original repository for some products.

Install Percona for MySQL

Now that the Percona repository is installed, you can install the server. To do that, run the commands below:

sudo percona-release setup ps80
sudo apt update
sudo apt install percona-server-server

The commands above enable the Percona repository, refresh the package archive and install Percona for the MySQL server. During the installation, you’ll be prompted to create a root password.

Package configuration

  ┌──────────────────┤ Configuring percona-server-server ├───────────────────┐
  │ Please provide a strong password that will be set for the root account   │ 
  │ of your MySQL database. Leave it blank to enable password less login     │ 
  │ using UNIX socket based authentication.                                  │ 
  │                                                                          │ 
  │ Enter root password:                                                     │ 
  │                                                                          │ 
  │ ********________________________________________________________________ │ 
  │                                                                          │ 
  │                              <Ok>                                        │ 
  │                                                                          │ 

If you run legacy applications like phpMyAdmin and others, you’ll want to use the legacy authentication options as highlighted below:

Package configuration

 ┌───────────────────┤ Configuring percona-server-server ├────────────────────┐
 │ Select default authentication plugin                                       │
 │                                                                            │
 │     Use Strong Password Encryption (RECOMMENDED)                           │
 │     Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)      │
 │                                                                            │
 │                                                                            │
 │                                <Ok>                                        │
 │                                                                            │

Like MySQL, you can run the commands below to secure MySQL installation.

sudo mysql_secure_installation

Then use the guide below to answer the prompts:

Securing the MySQL server deployment.

Enter password for user root: 

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No: N 
Using existing password for root.
Change the password for root ? ((Press y|Y for Yes, any other key for No) : N

 . skipping.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production

Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y

Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y
 - Dropping test database.
 - Removing privileges on test database.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y

All done! 

That’s it!

Now you can log in to Percona for MySQL using the same command as below:

sudo mysql -u root -p


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.13-3 Percona Server (GPL), Release '3', Revision 'a920dd6'

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

You may also like the post below:

Posted by

I love computers; maybe way too much. What I learned I try to share at

Leave a Reply

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

%d bloggers like this: