Re: [cobalt-users] MySQL default password

["domino27" <domino27@xxxxxxxxxxxx>]

----- Original Message -----
From: "Andy Clyde, oxfordmusic.net" <andy.clyde@xxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Tuesday, February 04, 2003 5:26 PM
Subject: Re: [cobalt-users] MySQL default password


>
> > Hi All,
> >
> > I've just installed MySQL on a new server from the PKG at pkgmaster.com.
> > I'm trying to reset the root password.  It says at the top of the
> pkgmaster
> > page that the password is:
> >
> > cobalt-mysql
> >
> > I've tried this and it won't let me in.  I've also tried not using a
> > password at all.  Nothing seems to work.  It's a new server and hasn't
had
> > MySQL installed on it before... or so I believed when I took out the
> > contract on it!
> >
>
> How to Reset a Forgotten Password
>
> If you have forgotten the root user password for MySQL, you can restore it
> with the following procedure:
>
>
> 1.  Take down the mysqld server by sending a kill (not kill -9) to the
> mysqld server.  The pid is stored in a .pid file, which is normally in the
> MySQL database directory:
>
>
> kill `cat /mysql-data-directory/hostname.pid`
>
> You must be either the Unix root user or the same user the server runs as
to
> do this.
>
> 2.  Restart mysqld with the --skip-grant-tables option.
>
>  3.  Connect to the mysqld server with mysql -h hostname mysql and change
> the password with a GRANT command. See GRANT.  You can also do this with
> mysqladmin -h hostname -u user password 'new password'
>
>  4.  Load the privilege tables with: mysqladmin -h hostname
flush-privileges
> or with the SQL command FLUSH PRIVILEGES.
>
> Note that after you started mysqld with --skip-grant-tables, any usage of
> GRANT commands will give you an Unknown command error until you have
> executed FLUSH PRIVILEGES.
>
> there's a really good MySQL help file for stuff like this you can download
> from www.mysql.com (or else just search the online version on the
website).
>
> andy



I`ve just been through all this.. Assuming I`m talking about the same
thing.. it sounds like it.

I found that if I reset the DSN in the ASP server config from the control
panel it all MySql will work OK and as advertised.
Check out the Chillisoft HowTo at Packagemaster (pkgmaster.com) ... took me
just 5 minutes. (I`d spent 5 hours in the archives :-)

Dave Robinson



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