Home / server / Questions / 614226
Accepted
Roy Hinkley
Asked: 2014-07-22 08:20:33 +0800 CST

how to find mysql binary in redhat

  • 772

I am working with a Redhat distribution. The network admin is inaccessible so I have no ability to request information.

Using bash, how do I find the mysql binary so that I can run sql commands?

mysql -u user -p password
-bash: mysql: command not found

So they did not set up the path.

linux

4 Answers

  1. Best Answer

    It usually should be in the path already and can be executed with just calling mysql in the shell.

    If that's not working (and you have reason to expect the mysql CLI binary to be installed), you can try to find it with find: 

     find / -name mysql -type f

    Example: 

    find / -name mysql -type f
/usr/bin/mysql
    • 4

  2. MySQL consists of two components, the MySQL server which is the actual database engine and the MySQL client, used to communicate with the database server from the command line.

    The MySQL client is installed from the plain mysql software package. If it isn't available (check with rpm -q mysql) use yum install mysql after which the mysql command should available in your regular path or by it's default absolute path /usr/bin/mysql.

    • 1

  3. Run the following command:

    which mysql

    Example where no MySQL binary is installed:

    cwatson@thor:~$ which mysql
cwatson@thor:~$

    Examlple where MySQL binary is installed to /usr/bin/mysql:

    cwatson@cwatson-desktop ~/Desktop $ which mysql
/usr/bin/mysql
cwatson@cwatson-desktop ~/Desktop $

    Typically though, if just running mysql from the command line results in "comamnd not found", then the binary is not in your user's PATH, or is not installed at all.

    • 0

  4. Verify that the mysql package is installed, e.g.,:

    rpm -qi mysql

    or rpm -qa |grep mysql

    Note that the server itself is packaged as mysql-server.

    If it's not installed, you will need to install the client, though this will require root privileges to do so:

    yum install mysql
    • 0