List:General Discussion« Previous MessageNext Message »
From:Varuna Seneviratna Date:October 4 2008 11:32am
Subject:Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
View as plain text  
Hi Ian Thanks!
    Your advice worked.I have another problem.I stopped the service from the
services shortcut in the Administrative tools.then according to to the
reference manual to start the server for the first time the command to run
is given as C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"
--console

But it didn't work, the following was the displayed message

'"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"' is not recognized as
an i
nternal or external command,
operable program or batch file.

*But when I used "mysqld-nt" The following is the out put*

C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --console
081004 16:56:01  InnoDB: Started; log sequence number 0 43655
081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were
used; s
o replication may break when this MySQL server acts as a slave and has his
hostn
ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid
this p
roblem.
081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: re
ady for connections.
Version: '5.0.67-community-nt'  socket: ''  port: 3306  MySQL Community
Edition
(GPL)

1 In the reference manual there are three server types how can I start the
mysqld server?
2 What is the difference between installing MySQL as a server and a service,
Is it only that when installed as a service MySQL server starts when Windows
starts and when Windows stops it stops?
3 After starting the server in above mentioned way How can I use MySQL
server Do I have to open another console window and do what?


Thanks Varuna


On Sat, Oct 4, 2008 at 2:19 PM, Ian Simpson <ian@stripped> wrote:

> 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 ODBC@localhost, rather than root@localhost.
>
> 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
>
>
>

Thread
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'Varuna Seneviratna4 Oct
  • Re: mysqladmin: connect to server at 'localhost' failed error: 'Accessdenied for user 'ODBC'@'localhost' (using password: YES)'Pintér Tibor4 Oct
  • Re: mysqladmin: connect to server at 'localhost' failed error: 'Accessdenied for user 'ODBC'@'localhost' (using password: YES)'Andy Shellam4 Oct
  • Re: mysqladmin: connect to server at 'localhost' failed error:'Access denied for user 'ODBC'@'localhost' (using password: YES)'Ian Simpson4 Oct
    • Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'Varuna Seneviratna4 Oct