RE: [cobalt-users] MySQL Password

["Andy Jacobs" <andy@xxxxxxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Simon Liddicott
> Sent: 18 July 2003 11:29
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: Re: [cobalt-users] MySQL Password
>
>
>
> ----- 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

I've got phpMyAdmin installed for the site but I didn't do it from a pkg.  I
think I need to get this password thing sorted before I do anything else.

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