发布于

安装Percona Server 8.0版本数据库

作为MYSQL的衍生社区版本，Percona以其优秀的迭代速度和有异于ORACLE社区版及MARIA DB版本的新特性，给数据开发者带来了更多的选择。

2018年Percona也升级了其下的Percona Server 8.0。这里演示如何在CentOS下安装Percona Server8.0及启用特色存储引擎.

1.安装Percona YUM源：

$ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

2.设定Yum源使用Percona的版本为8.0

$ sudo percona-release setup ps80

3.安装数据库

$ sudo yum install percona-server-server

4.运行Percona Server for MySQL

$ sudo service mysql start

5.确认运行状态

$ sudo service mysql status

6.关闭Percona或重启Percona

$ sudo service mysql stop
$ sudo service mysql restart

7.找到安装临时root密码

 grep "A temporary password" /var/log/mysqld.log

你会得到结果临时密码；但是如果无法出现可以试着重启Percona Server

2019-01-04T16:56:48.430540Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 临时密码

8.初始化数据库,修改默认密码，注意8.0默认有强制密码强度要求。

mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.

Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) :

 ... 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
environment.

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


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
Success.

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
environment.


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

 - Removing privileges on test database...
Success.

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
Success.

All done!

9.解决phpMyadmin因加密认证不一样导致无法连接的问题

mysql -p
Enter password:
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '你的密码';
Query OK, 0 rows affected (0.26 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)