Control Web Panel

WebPanel => MySQL => Topic started by: Spaceman-Spiff on March 14, 2017, 06:54:13 PM

Title: Cannot run mysqltuner
Post by: Spaceman-Spiff on March 14, 2017, 06:54:13 PM

I keep getting errors running mysqltuner. Even when I tried with sudo or passing on the username/password.

Code: [Select]

[root@home ~]# perl mysqltuner.pl
 >>  MySQLTuner 1.7.1 - 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: 1792
[!!] You probably doesn't get enough privileges for running MySQLTuner ...
The only difference when I pass on credentials is and server/port:

Code: [Select]

[--] Skipped version check for MySQLTuner script
[--] Performing tests on localhost:3306
[OK] Logged in using credentials passed on the command line
[!!] failed to execute: SELECT VERSION()
[!!] FAIL Execute SQL / return code: 1792
[!!] You probably doesn't get enough privileges for running MySQLTuner ...
Using CentOS Linux release 7.3.1611 (Core)
Kernel Version: 4.9.7-x86_64-linode80
Platform: x86_64 [kvm]
CWP version: 0.9.8.279
DB version: 10.1.21-MariaDB