RE: [cobalt-users] MySQL Password

["Andy Jacobs" <andy@xxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Laurent GROUSSET
> Sent: 18 July 2003 11:07
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: Re: [cobalt-users] MySQL Password
>
>
> Hi,
>
> The defaut MySQL root password is nopassword.
>
> Laurent.

Hi Laurent,

Thanks for that.  I'm a bit confused now. I set up a quick connection to
test this and I put cobalt-mysql for the password and it all works.  The BIG
problem at the moment is that I have 2 sites running where I have had to use
the root user and defaul password to get their sites going again.

If it had no password and I entered one anyway, would it just ignore it?

Andy




>
> ----- Original Message -----
> From: "Andy Jacobs" <andy@xxxxxxxxxxxxxxx>
> To: <cobalt-users@xxxxxxxxxxxxxxx>
> Sent: Thursday, July 17, 2003 11:00 PM
> Subject: [cobalt-users] MySQL Password
>
>
> > Hi folks
> >
> > I've just installed MySQL from pkgmaster and am having a
> problem changing
> > the password from the default, amongst other things.
> >
> > I log in as admin, do a su -, type in my password again and
> then enter the
> > following:
> >
> > mysqladmin -uroot -pcobalt-mysql password whatever
> >
> > It just comes back with the options for mysqladmin as if I've typed
> > something wrong.  I also get this if I just try mysqladmin -uroot
> > -pcobalt-mysql
> >
> > I've looked through the archives and can't find anything wrong with what
> I'm
> > typing.
> >
> > Any ideas?
> >
> > Also, I've just installed phpMyAdmin and when Ido:
> >
> >
> > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on
> > bluewidgets.* TO clientusername@localhost IDENTIFIED by
> > "clientusernamepassword";
> >
> > I get an error unless I put clientusername@localhost in "" as well.  It
> then
> > goes through without an error but the user doesn't seem to be created.
> >
> > I've used this command many times on my old server running
> phpMyAdmin-2.2.0
> > but I've used phpMyAdmin-2.5.2 on this server.
> >
> > Lastly, as far as MySQL is concerned, is 'group' some sort of internal
> > label?  I had a database on the old server using group in a
> table.  I did
> a
> > dump and copied it onto the new server and it didn't like it a bit.
> >
> > Again, any ideas gratefully received.
> >
> > --
> > Andy Jacobs
> > www.redcatmedia.net
> > T: 0845 644 6720
> >
> > _____________________________________
> > cobalt-users mailing list
> > cobalt-users@xxxxxxxxxxxxxxx
> > To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> > http://list.cobalt.com/mailman/listinfo/cobalt-users
> >
>
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003