No need to reinstall!! ;)
Form the MySQL docs:
If you have forgotten the root user password for MySQL, you can restore it
with the following procedure.
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.
Restart mysqld with the --skip-grant-tables option.
Connect to the mysqld server with mysql -h hostname mysql and change the
password with a GRANT command. See section 7.26 GRANT and REVOKE syntax. You
can also do this with mysqladmin -h hostname -u user password 'new password'
Load the privilege tables with: mysqladmin -h hostname flush-privileges or
with the SQL command FLUSH PRIVILEGES.
--
Niall Kavanagh ([EMAIL PROTECTED])
News, resources, and articles for web professionals and developers:
http://www.kst.com
> -----Original Message-----
> From: Paul Lussier [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 22, 2000 2:06 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL question
>
>
>
> Hi all,
>
> Does anyone know how to log into a MySQL database if the
> password you though
> you set doesn't work ?
>
> I'm getting ready to re-install the thing! :)
>
>
> --
>
> Seeya,
> Paul
> ----
> Doing something stupid always costs less (up front) than doing
> something intelligent.
> Bean counters are *always* wrong!
> A conclusion is simply the place where you got tired of thinking.
> If you're not having fun, you're not doing it right!
>
>
>
> **********************************************************
> To unsubscribe from this list, send mail to
> [EMAIL PROTECTED] with the following text in the
> *body* (*not* the subject line) of the letter:
> unsubscribe gnhlug
> **********************************************************
>
**********************************************************
To unsubscribe from this list, send mail to
[EMAIL PROTECTED] with the following text in the
*body* (*not* the subject line) of the letter:
unsubscribe gnhlug
**********************************************************
