Well, since I don't feel like typing a whole lot, I'll just let Niall speak :)
------- Forwarded Message
From: Niall Kavanagh <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: MySQL question
Date: Tue, 22 Feb 2000 14:19:50 -0500
No need to reinstall!! ;)
>From 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
------- End of Forwarded Message
--
Seeya,
Paul
----
Doing something stupid always costs less (up front)
than doing something intelligent.
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
**********************************************************
