How to install Percona MySql Server 8 on Linux Centos 7
How to install Percona MySql Server 8 on Centos 7
[root@localhost ~]# yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
Loaded plugins: fastestmirror
percona-release-latest.noarch.rpm | 17 kB 00:00:00
Examining /var/tmp/yum-root-Mo8_Vd/percona-release-latest.noarch.rpm: percona-release-1.0-12.noarch
Marking /var/tmp/yum-root-Mo8_Vd/percona-release-latest.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package percona-release.noarch 0:1.0-12 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================================================================================
Package Arch Version Repository Size
======================================================================================================================================
Installing:
percona-release noarch 1.0-12 /percona-release-latest.noarch 19 k
Transaction Summary
======================================================================================================================================
Install 1 Package
Total size: 19 k
Installed size: 19 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : percona-release-1.0-12.noarch 1/1
* Enabling the Percona Original repository
<*> All 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.
For more information, please visit:
https://www.percona.com/doc/percona-repo-config/percona-release.html
Verifying : percona-release-1.0-12.noarch 1/1
Installed:
percona-release.noarch 0:1.0-12
Complete!
[root@localhost ~]#
Enable percona server 8.0 repo
[root@localhost ~]# percona-release setup ps80
* Disabling all Percona Repositories
* Enabling the Percona Server 8.0 repository
* Enabling the Percona Tools repository
<*> All done!
[root@localhost ~]#
[root@localhost ~]# sudo yum install percona-server-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.dionipe.net
* epel: epel.dionipe.id
* extras: mirror.dionipe.net
* updates: mirror.dionipe.net
Resolving Dependencies
--> Running transaction check
---> Package percona-server-server.x86_64 0:8.0.16-7.1.el7 will be installed
--> Processing Dependency: percona-server-shared for package: percona-server-server-8.0.16-7.1.el7.x86_64
--> Processing Dependency: percona-server-client for package: percona-server-server-8.0.16-7.1.el7.x86_64
--> Processing Dependency: net-tools for package: percona-server-server-8.0.16-7.1.el7.x86_64
--> Running transaction check
---> Package net-tools.x86_64 0:2.0-0.24.20131004git.el7 will be installed
---> Package percona-server-client.x86_64 0:8.0.16-7.1.el7 will be installed
---> Package percona-server-shared.x86_64 0:8.0.16-7.1.el7 will be installed
--> Processing Dependency: percona-server-shared-compat for package: percona-server-shared-8.0.16-7.1.el7.x86_64
--> Running transaction check
---> Package percona-server-shared-compat.x86_64 0:8.0.16-7.1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================================================================================
Package Arch Version Repository Size
======================================================================================================================================
Installing:
percona-server-server x86_64 8.0.16-7.1.el7 ps-80-release-x86_64 51 M
Installing for dependencies:
net-tools x86_64 2.0-0.24.20131004git.el7 base 306 k
percona-server-client x86_64 8.0.16-7.1.el7 ps-80-release-x86_64 11 M
percona-server-shared x86_64 8.0.16-7.1.el7 ps-80-release-x86_64 1.2 M
percona-server-shared-compat x86_64 8.0.16-7.1.el7 ps-80-release-x86_64 1.2 M
Transaction Summary
======================================================================================================================================
Install 1 Package (+4 Dependent packages)
Total size: 64 M
Installed size: 347 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : net-tools-2.0-0.24.20131004git.el7.x86_64 1/5
Installing : percona-server-shared-compat-8.0.16-7.1.el7.x86_64 2/5
Installing : percona-server-shared-8.0.16-7.1.el7.x86_64 3/5
Installing : percona-server-client-8.0.16-7.1.el7.x86_64 4/5
Installing : percona-server-server-8.0.16-7.1.el7.x86_64 5/5
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://www.percona.com/doc/percona-server/8.0/management/udf_percona_toolkit.html for more details
Verifying : percona-server-client-8.0.16-7.1.el7.x86_64 1/5
Verifying : percona-server-shared-compat-8.0.16-7.1.el7.x86_64 2/5
Verifying : percona-server-server-8.0.16-7.1.el7.x86_64 3/5
Verifying : net-tools-2.0-0.24.20131004git.el7.x86_64 4/5
Verifying : percona-server-shared-8.0.16-7.1.el7.x86_64 5/5
Installed:
percona-server-server.x86_64 0:8.0.16-7.1.el7
Dependency Installed:
net-tools.x86_64 0:2.0-0.24.20131004git.el7 percona-server-client.x86_64 0:8.0.16-7.1.el7
percona-server-shared.x86_64 0:8.0.16-7.1.el7 percona-server-shared-compat.x86_64 0:8.0.16-7.1.el7
Complete!
[root@localhost ~]#
Start mysql Server
[root@localhost ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
[root@localhost matomo]# service mysql status
Redirecting to /bin/systemctl status mysql.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2019-08-30 23:21:41 WIB; 8s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 9322 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 9398 (mysqld)
Status: "SERVER_OPERATING"
CGroup: /system.slice/mysqld.service
└─9398 /usr/sbin/mysqld
Aug 30 23:21:32 localhost.localdomain systemd[1]: Starting MySQL Server...
Aug 30 23:21:41 localhost.localdomain systemd[1]: Started MySQL Server.
[root@localhost ~]#
Find the temporary password and login to mysql
[root@localhost ~]# sudo grep "temporary password" /var/log/mysqld.log
2019-08-30T17:17:39.872841Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: jd*qBqWtM7lU
[root@localhost ~]# 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.16-7
Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, 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> exit
Bye
[root@localhost ~]#
Update your temporary password before executing the statement
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyP@55';
Query OK, 0 rows affected (0.01 sec)
mysql>