[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] MySQL Password

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


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

sure, i was just thinking that if the mysqladmin was acting odd, you might
have more joy with phpmyadmin - maybe you should act as though you had
forgotten your password and restart mysql then reset the password

si

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