Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC''localhost' (using password: YES)'

From: Ian Simpson (ianit.myjobgroup.co.uk)
Date: Sat Oct 04 2008 - 03:49:56 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Varuna,

The problem looks like it is with the command you issued. The correct
syntax is:

mysqladmin -uroot -p shutdown

then supply root password.

Without giving the -uroot argument, it doesn't know that you are trying
to log in as the root user, which is why it is telling you that access
is denied for ODBClocalhost, rather than rootlocalhost.

Thanks

On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote:
> I am using WinXP.I am wanted to shutdown MySQL service from the command line
> and ran the command "mysqladmin" -p root shutdown next the root password was
> asked for,I entered the correct password, when I entered the password the
> below displayed error was the result
>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC''localhost' (using password: YES)'
>
>
>
> How can I correct this?
> Is this because of a firewall preventing access to port 3306?If a firewall
> is preventing access how was it able to ask for the password?
>
> I have Nortan Internet Security trial version running and the windows
> firewall is disabled.If this is caused by a firewall barrier please tell me
> how to open the port in Nortan Internet Security.
>
>
> Varuna
--
Ian Simpson
System Administrator
MyJobGroup

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]