cmd进入mysql 光标不见了_MySQL命令行'-bash找不到命令“

The following link at the end of the post was helpful but can someone clarify this.

There are 2 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 and at unix prompt type:

Macbookpro$./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:

$macbookpro mysql -u root -p

Enter password: xxxx

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

Second method from mysql> prompt

mysql> -u root -p

->

I also often get this error:

-bash command not found

I am unable to login to phpMyAdmin.

Thanks.

My problem is that I am getting this error message when trying to login to phpMyAdmin.

"Login without a password is forbidden by configuration"

The link that in have referenced above. Responses from 2013

解决方案

To use command i.e. $mysql on macbook terminal you need to export path using:

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

considering default installation use following command to get mysql prompt as root user:

mysql -u root

otherwise you are using wrong root password.