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
– iHaveAQuestion, Commented Mar 14, 2014 at 17:36
possible duplicate of can't access mysql from command line mac — kishanio
– kishanio, Commented Aug 15, 2015 at 13:23

Peter Mortensen · Accepted Answer · 2021-12-31 19:16:39Z

52

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, 2021 at 19:16

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 24, 2014 at 11:51

panther_

5243 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

iHaveAQuestion Over a year ago

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 :)

MER Over a year ago

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).

Peter Mortensen · Accepted Answer · 2021-12-31 19:17:27Z

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, 2021 at 19:17

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered May 3, 2017 at 12:59

Dan

931 silver badge5 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2021-12-31 19:19:38Z

1

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

edited Dec 31, 2021 at 19:19

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jun 17, 2020 at 19:13

Syed Muhammad Ahmad

4385 silver badges14 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2021-12-31 19:27:03Z

0

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).

edited Dec 31, 2021 at 19:27

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Dec 10, 2021 at 9:53

questionto42

9,9228 gold badges80 silver badges125 bronze badges

Collectives™ on Stack Overflow

MySQL command line '-bash command not found'

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related