Percona Server for MySQL su Ubuntu

Percona Server for MySQL è una distribuzione gratuita e open source del sistema di gestione di database relazionali MySQL creato da Percona. È un sostituto drop-in completamente compatibile per Oracle MySQL. In questa guida, vedremo come installare e configurare Percona Server for MySQL 8.0 su Ubuntu 18.04

apt update
apt install wget
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
percona-release setup ps80
apt install percona-server-server
$ mysql -u root -p
 Enter password: 
 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'
 Copyright (c) 2009-2018 Percona LLC and/or its affiliates
 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.
mysql> SELECT VERSION();
 +-----------+
 | VERSION() |
 +-----------+
 | 8.0.13-3  |
 +-----------+
 1 row in set (0.00 sec)
 mysql> QUIT;
nano /etc/my.cnf
[mysqld]
default_authentication_plugin=mysql_native_password
systemctl restart mysqld
mysql> CREATE DATABASE user_db;
mysql> CREATE USER 'user_db'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> GRANT ALL PRIVILEGES ON user_db.* TO 'user_db'@'localhost';

Leave a comment

Hey, so you decided to leave a comment! That's great. Just fill in the required fields and hit submit. Note that your comment will need to be reviewed before its published.