Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the installation process of the Percona MySQL 5.6RPM package, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

-- unpack the installation package

[root@localhost percona-xtrabackup-2.4.4-Linux-x86_64] # tar xvf Percona-Server-5.6.31-77.0-r5c1061c-el6-x86_64-bundle.tar

-- install the database

[root@localhost percona-xtrabackup-2.4.4-Linux-x86_64] # yum localinstall Percona-Server-server-56-5.6.31-rel77.0.el6.x86_64.rpm Percona-Server-client-56-5.6.31-rel77.0.el6.x86_64.rpm Percona-Server-shared-56-5.6.31-rel77.0.el6.x86_64.rpm

-- Editing configuration fil

[root@localhost mysql] # vim / etc/my.cnf

[mysqld]

Datadir=/var/lib/mysql

Socket=/var/lib/mysql/mysql.sock

Log-error=/var/log/mysqld.log

Innodb_buffer_pool_size = 128m

-- start the database

[root@localhost mysql] # mysqld_safe-- defaults-file=/etc/my.cnf &

[1] 3246

-- modify the ROOT password

[root@localhost mysql] # mysqladmin-u root password 'root'

Warning: Using a password on the command line interface can be insecure.

-- remove redundant root and anonymous users from the database, and keep only one root user locally

[root@localhost mysql] # mysql-u root-paired root`

Mysql > select host,user from mysql.user

+-+ +

| | host | user |

+-+ +

| | 127.0.0.1 | root |

| |:: 1 | root |

| | localhost |

| | localhost | root |

| | localhost.localdomain |

| | localhost.localdomain | root |

+-+ +

6 rows in set (0.00 sec)

Mysql > delete from mysql.user where (user,host) not in (select 'root','localhost')

Query OK, 5 rows affected (0.06 sec)

Mysql > commit

Query OK, 0 rows affected (0.00 sec)

Mysql > select host,user from mysql.user

+-+ +

| | host | user |

+-+ +

| | localhost | root |

+-+ +

1 row in set (0.00 sec)

-- View the running status of the database

[root@localhost mysql] # / etc/init.d/mysql status

SUCCESS! MySQL (Percona Server) running (6584)

After reading the above, do you have any further understanding of the installation process of the Percona MySQL 5.6 RPM package? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.