Well, this would help if I had forgotten the password, but I didn't. I
know what the password is, it just won't let me DO anything.... I can
log in if I do `mysql -u root:mysql`, mysql being the password.
Kenny
Paul Lussier wrote:
>
> 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
**********************************************************
