作为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)
发表回复