Access denied

Hi all,

Ive installed mysql for windows with apache. If i try to start mysql by
the command line i get the message: access denied for user
odcb@localhost (using password no)
Does this mean that i have to enter a password? How can i do this? Can i
use mysql without password?

Thanx,
WJ

WJ Zeeuwen wrote:
> Hi all,
>
> Ive installed mysql for windows with apache. If i try to start mysql by
> the command line i get the message: access denied for user
> odcb@localhost (using password no)
> Does this mean that i have to enter a password? How can i do this? Can i
> use mysql without password?

Read these sections of the manual:

http://dev.mysql.com/doc/refman/5.0/...onnecting.html
http://dev.mysql.com/doc/refman/5.0/...rivileges.html
http://dev.mysql.com/doc/refman/5.0/...anagement.html

Regards,
Bill K.

>Ive installed mysql for windows with apache. If i try to start mysql by
>the command line i get the message: access denied for user
>odcb@localhost (using password no)
>Does this mean that i have to enter a password?

Does the user odcb@localhost *HAVE* a password? (when you created
it with the GRANT command). Does that user even exist at all?
What does "SHOW GRANTS FOR odcb@localhost" show?

>How can i do this? Can i
>use mysql without password?

I consider using mysql without a password to be a very poor idea
unless (a) the *ONLY* access to the database is from localhost and
(b) you are the only user with a login on that machine, and (c) no
web page accepts browser-supplied usernames and/or passwords for
the database.

Gordon L. Burditt

On Fri, 05 May 2006 23:47:50 +0200, WJ Zeeuwen wrote:

> Hi all,
>
> Ive installed mysql for windows with apache. If i try to start mysql by
> the command line i get the message: access denied for user
> odcb@localhost (using password no)
> Does this mean that i have to enter a password? How can i do this? Can i
> use mysql without password?

WJ,

All you have to do is type:

mysqladmin -u username -p status

and it will prompt you for the password.

If you do not want to have to enter a password, then
you have to create a file, as noted here:

http://72.14.207.104/linux?q=cache:P...&ct=clnk&cd=11

I am very new to mysql myself so I just learned this
today.

Have fun with it!

WJ Zeeuwen wrote:
> Hi all,
>
> Ive installed mysql for windows with apache. If i try to start mysql
> by the command line i get the message: access denied for user
> odcb@localhost (using password no)
> Does this mean that i have to enter a password? How can i do this?
> Can i use mysql without password?
>
> Thanx,
> WJ

Try mysql -u root