gpt4 book ai didi

MySqlTuner - 失败 : return code 256

转载 作者:行者123 更新时间:2023-11-29 21:09:39 24 4
gpt4 key购买 nike

我们正在尝试使用 mysqltuner 来了解我们的 WordPress 网站上某些问题背后可能存在的问题,但在运行它时几乎没有出现问题(主要是无法执行/返回代码:256)。

首先我们做了:

wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

并执行它:

perl mysqltuner.pl

但这就是我们得到的:

 >>  MySQLTuner 1.6.9 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[!!] failed to execute: SELECT VERSION()
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW /*!50000 GLOBAL */ VARIABLES
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW /*!50000 GLOBAL */ STATUS
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW ENGINES
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW SLAVE STATUS\G
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SHOW SLAVE HOSTS
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: \s
[!!] FAIL Execute SQL / return code: 256
Use of uninitialized value $myvar{"version"} in pattern match (m//) at
mysqltuner.pl line 1526 (#1)
(W uninitialized) An undefined value was used as if it were already
defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
To suppress this warning assign a defined value to your variables.

To help you figure out what was undefined, perl will try to tell you the
name of the variable (if any) that was undefined. In some cases it cannot
do this, so it also tells you what operation you used the undefined value
in. Note, however, that perl optimizes your program and the operation
displayed in the warning may not necessarily appear literally in your
program. For example, "that $foo" is usually optimized into "that "
. $foo, and the warning will refer to the concatenation (.) operator,
even though there is no . in your program.

Use of uninitialized value $mysqlvermajor in numeric gt (>) at mysqltuner.pl
line 1552 (#1)
Use of uninitialized value $mysqlvermajor in numeric eq (==) at mysqltuner.pl
line 1552 (#1)
Use of uninitialized value $myvar{"version"} in concatenation (.) or string at
mysqltuner.pl line 1531 (#1)
[!!] Your MySQL version is EOL software! Upgrade soon!
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[!!] failed to execute: SHOW DATABASES
[!!] FAIL Execute SQL / return code: 256
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[OK] Total fragmented tables: 0
[!!] failed to execute: SELECT ~0
[!!] FAIL Execute SQL / return code: 256

-------- Security Recommendations -------------------------------------------
Use of uninitialized value $myvar{"version"} in pattern match (m//) at
mysqltuner.pl line 1345 (#1)
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE TRIM(USER) = '' OR USER IS NULL
[!!] FAIL Execute SQL / return code: 256
[OK] There are no anonymous accounts for any database users
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (password = '' OR password IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket')
[!!] FAIL Execute SQL / return code: 256
[OK] All database users have passwords assigned
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE CAST(password as Binary) = PASSWORD(user) OR CAST(password as Binary) = PASSWORD(UPPER(user)) OR CAST(password as Binary) = PASSWORD(UPPER(LEFT(User, 1)) + SUBSTRING(User, 2, LENGTH(User)))
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE HOST='%'
[!!] FAIL Execute SQL / return code: 256
[!!] There is no basic password file list!

-------- CVE Security Recommendations ---------------------------------------
[--] Skipped due to --cvefile option undefined
Use of uninitialized value $mystat{"Questions"} in numeric lt (<) at
mysqltuner.pl line 1868 (#1)
[!!] Your server has not answered any queries - cannot continue...

我们不明白可能出现什么问题。预先感谢大家!

最佳答案

由于更改listen端口/重命名root用户并禁用无密码本地登录,我遇到了同样的错误,但通过以下方式修复了它:

/path/to/mysqltuner.pl --port xxxx --user xxxx --pass xxxx

(假设localhost没有--host开关,端口3306假设没有--port > 开关)

运行mysqltuner的更好方法是使用limited_user的一些凭据设置/root/.my.cnf (任何名称都可以):

[client]
user=limited_user
pass=thatuserspassword

然后我就可以使用limited_user运行:

/path/to/mysqltuner.pl --port 5555 --user limit_user

limited_user 只需要以下权限:

显示数据库、锁定表、选择 *.*

&可选显示从属状态显示从属主机

关于MySqlTuner - 失败 : return code 256,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/36501682/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com