Add the -p option to tell mySQL to ask for a password.
For example
c:\mysql\bin\mysql -u root -p
Or if you want to give the password without a prompt
c:\mysql\bin\mysql -u root -p YourPassWord
Or if you are connecting on another Server
c:\mysql\bin\mysql -u root -h RemoteServerAddress -p
Hope this helps
Thanks
Emery
----- Original Message -----
From: "Stephan Wölfel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 18:05
Subject: Re: Error 1045
> But MySQL even doesn't ask me for a password but returns immediately this
> error.
>
> ----- Original Message -----
> From: "gerald_clark" <[EMAIL PROTECTED]>
> To: "Stephan Wölfel" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, October 13, 2003 10:14 PM
> Subject: Re: Error 1045
>
>
> > You are not entering the right password.
> > If you did NOT set a password for root, then leave the -p option off.
> >
> > Stephan Wölfel wrote:
> >
> > >When I start MySQL with "mysql -u root -p" I get again the error 1045
> > >("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
> > >What am I doing wrong ?
> > >
> > >----- Original Message -----
> > >From: "gerald_clark" <[EMAIL PROTECTED]>
> > >To: "Stephan Wölfel" <[EMAIL PROTECTED]>
> > >Cc: <[EMAIL PROTECTED]>
> > >Sent: Monday, October 13, 2003 5:54 PM
> > >Subject: Re: Error 1045
> > >
> > >
> > >
> > >
> > >>Stephan Wölfel wrote:
> > >>
> > >>
> > >>
> > >>>Thanks for the advise.
> > >>>However I have some additional questions:
> > >>>ad 2) How can I check the grant privileges ?
> > >>>ad 3) How can I "run this as the mysql root user" ?
> > >>>
> > >>>
> > >>>
> > >>mysql -u root -p
> > >>enter the root password you set when you installed mysql
> > >>use mysql
> > >>enter the grant command.
> > >>
> > >>
> > >>
> > >>>----- Original Message -----
> > >>>From: "gerald_clark" <[EMAIL PROTECTED]>
> > >>>To: "Stephan Wölfel" <[EMAIL PROTECTED]>
> > >>>Cc: <[EMAIL PROTECTED]>
> > >>>Sent: Monday, October 13, 2003 4:47 PM
> > >>>Subject: Re: Error 1045
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>
> > >>--
> > >>MySQL General Mailing List
> > >>For list archives: http://lists.mysql.com/mysql
> > >>To unsubscribe:
> > >>
> > >>
> > >http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> > >>
> > >>
> > >___________________________________________________________
> > >M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
> > >Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
> > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> _____________________________________________________________
> Schlappe =DCbertragungsgrenze? http://my-mail.ch/?redirect=3D9904
> Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
