安装tokudb的初始密码问题

问题描述

MySQL 5.7 及同系产品在增加了很多安全控制。

初始密码仅能用1次，无法用于 ps_tokudb_admin指令中。

查询初始密码（首次登陆后，如不修改密码，则无法执行任何操作，包括help命令都无法执行。）

初始密码/var/log/mysqld.log

[root@ZABBIXPR01]# ps_tokudb_admin --enable -uroot -p
Enter password:

Checking SELinux status...
INFO: SELinux is disabled.

ERROR: Failed to list mysql plugins! Please check username, password and other options for connecting to server...

解决方法

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY "新密码";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

[root@ZABBIXPR01]# ps_tokudb_admin --enable -uroot -p
Enter password:

Checking SELinux status...
INFO: SELinux is disabled.

Checking if Percona Server is running with jemalloc enabled...
INFO: Percona Server is running with jemalloc enabled.

Checking transparent huge pages status on the system...
INFO: Transparent huge pages are enabled (should be disabled).

Checking if thp-setting=never option is already set in config file...
INFO: Option thp-setting=never is not set in the config file.
      (needed only if THP is not disabled permanently on the system)

Checking TokuDB engine plugin status...
INFO: TokuDB engine plugin is not installed.

Disabling transparent huge pages for the current session...
INFO: Successfully disabled transparent huge pages for this session.

Adding thp-setting=never option into /etc/my.cnf
INFO: Successfully added thp-setting=never option into /etc/my.cnf

Installing TokuDB engine...
INFO: Successfully installed TokuDB engine plugin.