Author Topic: Cannot run mysqltuner  (Read 540 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Cannot run mysqltuner
« 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