mySQL Password Validation

mysql> grant  all privileges on *.* to 'zozimos'@'%';
Query OK, 0 rows affected (0.00 sec)
  Went into database , created user with password and granted all.   Still getting ' password authentication failed.  Please verify that the username and password are correct' when i try logging in.  
Is there something else i need for authentication on that password?
xoxomosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
A MySQL user consists of username, password, and host.  A user with '%' for anyhost is not the same as a user for 'localhost' even though it is common to give them both the same username and password.

If you login in locally (on the same machine), then you are using 'localhost'.  If you login over the network from another machine, then you are using '%' (anyhost) or possibly a specific host or IP address.

https://dev.mysql.com/doc/refman/5.5/en/user-account-management.html
0
arnoldCommented:
in support of Dave's point, it is one option, the other did you run flush privileges after the grant?
This is needed to "reload" the security settings.
The password you set if it is using special characters @! There steps.

At times the issue stat you need to specify the db
mysql -u username -p database
If you are passing the password on the command line it either has to be in the form -ppassword --password=password on the line.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
xoxomosAuthor Commented:
I was reading about that 'flush' and suspected that was the problem but apparently had not enough brain to wrap around the concept. :-(   Big thanks.
0
xoxomosAuthor Commented:
Thanx all.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.