Re: [cobalt-users] MySQL Password

["Simon Liddicott" <simon@xxxxxxxxxxxx>]

----- Original Message -----
From: "Andy Jacobs" <andy@xxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Friday, July 18, 2003 11:24 AM
Subject: RE: [cobalt-users] MySQL Password


>
>
> > -----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

if was you i would install phpMyAdmin

you can get a pkg at http://www.solarspeed.net/downloads/index.php

http://ns2.solarspeed.net/downloads/RaQ34-phpMyAdmin-2.2.6.pkg

simon


>
>
>
>
> >
> > ----- 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
>
> _____________________________________
> 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
>