安装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.