mysql

centos123 · 04-21-2011, 11:53 AM

iam not able to connect localhost in mysql.i uswd command for mysql is

#mysqladmin -u root -h localhost password "123456"

ErroR:-

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

what to do?

lrtward · 04-21-2011, 12:24 PM

Okay I see a couple of problems.

1. You have a space between -p and the password. Get rid of it.
2. You aren't providing any command for mysqladmin to run. The syntax should be

Quote:

mysqladmin -u root -p12345 ping

Of course, you'd use whatever command you wanted to run; not necessarily ping.