Jumat, 30 Agustus 2019

How to install Percona MySql Server 8 on Linux Centos 7

  Tidak ada komentar
How to install Percona MySql Server 8 on Centos 7
[[email protected] ~]# 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!
[[email protected] ~]#
Enable percona server 8.0 repo
[[email protected] ~]# percona-release setup ps80
* Disabling all Percona Repositories
* Enabling the Percona Server 8.0 repository
* Enabling the Percona Tools repository
<*> All done!
[[email protected] ~]#
Install percona server
[[email protected] ~]# 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!
[[email protected] ~]#
Start mysql Server
[[email protected] ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
[[email protected] 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.
[[email protected] ~]#
Find the temporary password and login to mysql
[[email protected] ~]# 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 [email protected]: jd*qBqWtM7lU
[[email protected] ~]# 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
[[email protected] ~]# 
Update your temporary password before executing the statement
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '[email protected]';
Query OK, 0 rows affected (0.01 sec)

mysql>

Tidak ada komentar :

Posting Komentar