Re: [LI] MySQL

[Uday Kumar Khatua <udayk@xxxxxxxxxxxxxx>]

> #mysqladmin -u root password xyz123 is denies access to root@localhost
>

Doctor, the syntax is
mysqladmin -u root -p <command>
then it asks for password from the tty.
writing #mysqladmin -u root password xyz123
    =>    #mysqladmin -u root [no password] <change password to xyz123>

If your mysql root is not password protected it will set the password to xyz123.

If it is then it will deny access as you are trying to access without a passwd.

try
<snip>
# mysqladmin -u root -p ping
Enter password:
mysqld is alive
</snip>

This pings mysql after asking for password.
alternately u can give
#mysql -u root -p xyz123 ping
but this will expose your password to anyone doing a w at the same time.

regards
Uk

>
> What to do?
>
> ________

--------------------------------------------------------------------
The Linux India Mailing List Archives are now available.  Please search
the archive at http://lists.linux-india.org/ before posting your question
to avoid repetition and save bandwidth.