Re: [cobalt-users] MySQL

["David Thacker" <David@xxxxxxxxxxxxxx>]

Michael,

I got several similar error messages trying to set my root MySQL password as
well, but finally did get it to work.  I tried so many combinations of things
I can't recall exactly what command I used, but it was something like:

mysqladmin       (which logged me in as root without a password)

password xxxxxxxx         (which set my root password)

Good luck!

dAvid tHacker                                  Email: David@xxxxxxxxxxxxxx
Thacker Network Technologies Inc.                Http://www.ThackerNet.com


>
> Unfortunately I get a
>
> "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
>
> when I try that - I never changed the password on installing MySQL last
> week.
>
> Mike
>
> On Thu, 4 May 2000, Rodney wrote:
>
> > Greetings,
> > From
> >
http://www.gina.net/mysql/Manual_chapter/manual_Privilege_system.html#Default_
privileges
> >
> >     " The MySQL root user is created as a superuser who can do anything.
> > Connections must be made from the local host. Note: The initial root
> > password is empty, so anyone can connect as root without a password and be
> > granted all privileges.
> >      An anonymous user is created that can do anything with databases that
> > have a name of 'test' or starting with 'test_'. Connections must be made
> > from the local host. This means any local user can connect without a
> > password and be treated as the anonymous user.
> >      Other privileges are denied. For example, normal users can't use
> > mysqladmin shutdown or mysqladmin processlist. "
> >
> > If on a telnet session you type mysql -u root and can connect, you need to
> > set the root password...
> > mysql>SET PASSWORD FOR root=PASSWORD('new_password');
> >
> > Me thinks,
> > --Rodney
> >
> >
> > "Michael D. Bathrick" wrote:
> >
> > > I'm trying to set up the mysql password, but I need to know the default
> > > password to do so.
> >
> >
> > _______________________________________________
> > cobalt-users mailing list
> > cobalt-users@xxxxxxxxxxxxxxx
> > To Subscribe or Unsubscribe, please go to:
> > http://list.cobalt.com/mailman/listinfo/cobalt-users
> >
>
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>