MySQL command line '-bash command not found'

Question

The following link at the end of the post was helpful, but can someone clarify this? There are two answers that are in complete conflict, so I am asking about it.

One person responds that you should get to the MySQL command line like this.

Navigate to the directory

/usr/local/mysql/bin

And at a Unix prompt, type:

./mysql

Then type the following to reset the password.

mysql -u root -p

But then another person says:

No, you should run mysql -u root -p in bash, not at the MySQL command-line. If you are in mysql, you can exit by typing exit.

Neither of these work for me.

First method. From the Bash prompt:

mysql -u root -p

Enter password:  xxxx
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Second method from the mysql> prompt:

mysql> -u root -p
    ->

I also often get this error:

-bash command not found

I am unable to log in to phpMyAdmin.

My problem is that I am getting this error message when trying to log in to phpMyAdmin:

Login without a password is forbidden by configuration

The link that I have is referenced above. Responses from 2013:

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'db'

These are the first sentences of instructions "On Unix, use the following procedure to reset the password for all MySQL root accounts. The instructions assume that you will start the server so that it runs using the Unix login account that you normally use for running the server". Start the server. Which server ? The apache server ? I just open terminal and apache is running anyway that is unless I one apachectl stop. — iHaveAQuestion, Mar 14 '14 at 17:36
possible duplicate of [can't access mysql from command line mac](http://stackoverflow.com/questions/8195418/cant-access-mysql-from-command-line-mac) — kishanio, Aug 15 '15 at 13:23

score 51 · Answer 1 · edited Dec 31 '21 at 19:16

51

To use the command, i.e., mysql on a MacBook terminal, you need to export the path using:

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

Considering the default installation, use the following command to get the mysql prompt as the root user:

mysql -u root

Otherwise you are using the wrong root password.

Reference: Setting the MySQL root user password on OS X

edited Dec 31 '21 at 19:16

Peter Mortensen

30,738
21
105
131

answered Mar 24 '14 at 11:51

panther_

514
3
3

Thankyou Panther. I had gotten past that problem but today logged on about something else. I am keeping your above posted suggestions. They seem very logical of course :) – iHaveAQuestion Apr 29 '14 at 15:37
The above can solve the -13 error from child_process.spawn in node as well. (I had added what I thought was needed in the path... it worked for my login but did not work for node). – MER Oct 28 '20 at 22:56

score 7 · Answer 2 · edited Dec 31 '21 at 19:17

7

For a permanent solution -

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile
. ~/.bash_profile

Refer to details at this link.

edited Dec 31 '21 at 19:17

Peter Mortensen

30,738
21
105
131

answered May 03 '17 at 12:59

Dan

93
1
5

score 1 · Answer 3 · edited Dec 31 '21 at 19:19

You can permanently add PATH to your ~/.bash_profile file by the following. This will save you to run the export command every time you reopen the console or terminal.

Open the ~/.bash_profile file using
```
sudo nano ~/.bash_profile
```

Add the following line there

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

Save and exit the file and refresh the ~/.bash_profile file
```
source ~/.bash_profile
```
Enjoy

score 0 · Answer 4 · edited Dec 31 '21 at 19:27

I am not sure whether it is connected, but you might give it a try. It could be that you simply need MySQL on your local computer.

On your computer, run:

sudo apt-get update && sudo apt-get install mysql-server

Then you will get rid of such an error. I am not sure whether it is one of the errors you mean in the title "MySQL command line '-bash command not found'":

/home/.../some_bash_script.sh: line 123: mysql: command not found

With some luck, other errors that you get are connected to this. At least in my case, I got rid of a few other errors with this step, like ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111).

MySQL command line '-bash command not found'

4 Answers4

Linked