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'
4 Answers
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
For a permanent solution -
echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile. ~/.bash_profile
Refer to details at this link.
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_profileAdd the following line there
export PATH=$PATH:/usr/local/mysql/bin/Save and exit the file and refresh the ~/.bash_profile file
source ~/.bash_profileEnjoy
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).
