Shulou(Shulou.com)06/01 Report--

After installing MySQL (installation files), you cannot mysql directly on the command line.

Because the command line looks directly for the commands under / usr/local/bin, we need to put the commands of mysql into .bash _ profile.

Vim ~ / .bash_profile add: export PATH=$PATH:/usr/local/mysql/bin save, exit

Restart (load) the bash_profile file

Source / .bash_profile

Just do it.

# mysql-u root

-bash: mysql: command not found

Reason: this is because the system will look for the command under / usr/bin by default. If the command is not in this directory, of course you can't find it. All we need to do is map a link to the / usr/bin directory, which is equivalent to creating a link file.

First of all, we need to know the full path of the mysql command or mysqladmin command, for example, the path of mysql is: / usr/local/mysql/bin/mysql, we can execute the command like this:

# ln-s / usr/local/mysql/bin/mysql / usr/bin

The following is a supplement:

Under linux, when mysql is running normally, enter the mysql prompt:

Mysql command not found

Don't worry in the case of-bash: mysql: command not found. This is due to the lack of mysql in the / usr/local/bin directory. You only need to set up a soft link to solve the problem:

Map the mysql installation directory, such as MYSQLPATH/bin/mysql, to the / usr/local/bin directory:

# cd / usr/local/bin

# ln-fs / MYSQLPATH/bin/mysql mysql

Other commonly used commands such as mysqladmin, mysqldump and so on can be solved by this method when they are not available.

Note: where MYSQLPATH is the actual installation path of mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.