Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

[!!] Unable to find mysqladmin in your $PATH. Is MySQL installed? #20

Closed
Ch1mpooya opened this Issue Jun 18, 2012 · 9 comments

Comments

Projects
None yet
6 participants

i've compiled mysql from source 5.5.24 and now i cannot run mysqltunner.
any idea?

@ghost ghost assigned major Jun 18, 2012

Owner

major commented Jun 18, 2012

Try running:

which mysqladmin

If that doesn't work, try:

find / -name mysqladmin -type f

MySQLTuner checks for the mysqladmin executable in your path to see if it's installed.

well,
it's stored in /usr/local/mysql/bin/mysqladmin.

my $command = /usr/local/mysql/bin/mysqladmin; - didn't solve my problem.

TJM commented Jun 19, 2012

PATH=$PATH:/usr/local/mysql/bin

ok it works now!

Apart from [!!] Unable to find mysqladmin in your $PATH. Is MySQL installed? it also says... 'which' is not recognized as an internal or external command, and I added mysql/bin to the path

I receive the same error ''Unable to find mysqladmin in your $PATH. Is MySQL installed?'

MySQL is on a stand alond server, seperate from my Windows//IIS webserver. What should my PATH look like, do I need the ip address of the database server ie PATH=$PATH:111.222.333.444//usr/local/mysql/bin ? Or should I install and run mysql tuner on the stand alone database server instead?

TJM commented Nov 20, 2013

mysqltuner should be run on the database server.

pureche commented Jan 24, 2014

i still dont get it, where should i put PATH=$PATH:/usr/local/mysql/bin?

i've tried

my $command = PATH=$PATH:/usr/local/mysql/bin;

but it says

Global symbol "$PATH" requires explicit package name at ./mysqltuner.pl line 252.
Execution of ./mysqltuner.pl aborted due to compilation errors (#1)

im a complete noob at this, please help me.

i used find / -name mysqladmin -type f, and the path is /usr/local/mysql/bin/mysqladmin

Owner

major commented Feb 22, 2014

Sorry for the long delay on this issue. You can use the --mysqladmin flag to specify the path to your custom path if needed:

  # perl mysqltuner.pl --help

     MySQLTuner 1.2.0 - MySQL High Performance Tuning Script
     Bug reports, feature requests, and downloads at http://mysqltuner.com/
     Maintained by Major Hayden (major@mhtx.net) - Licensed under GPL

     Important Usage Guidelines:
        To run the script with the default options, run the script without arguments
        Allow MySQL server to run for at least 24-48 hours before trusting suggestions
        Some routines may require root level privileges (script will provide warnings)
        You must provide the remote server's total memory when connecting to other servers

     Connection and Authentication
        --host <hostname>    Connect to a remote host to perform tests (default: localhost)
        --socket <socket>    Use a different socket for a local connection
        --port <port>        Port to use for connection (default: 3306)
        --user <username>    Username to use for authentication
        --pass <password>    Password to use for authentication
        --mysqladmin <path>  Path to a custom mysqladmin executable

@major major closed this Feb 22, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment