RE: [K12OSN] mysql

[Henry Hartley <henryhartley westat com>]

>> -----Original Message-----
>> From: Peter Smit [mailto:peter smitti tmfweb nl] 
>> Sent: Sunday, November 02, 2003 10:56 AM
>> 
>> I have mysql installed on my K12Ltsp server and somehowe I
>> screwed the root password :(
>> 
>> I have searched th mysql site and tried everything i couldt
>> find over there.  But some how I cant fix it can't use the
>> commands they give in the reference manual I downloaded.
>> Does some now howto get this fixed?

According to the documentation I have:

1) Make yourself root (the system root, not the mysql root)
   and kill the mysqld server (my mysql-data-directory is
   /var/lib/mysql):

     kill `cat /<mysql-data-directory>/<hostname>.pid`

2) Restart mysqld with the --skip-grant-tables option.

3) Use mysqladmin to reset the password:

     mysqladmin -h hostname -u root password '<newpassword>'

4) Load the privilege tables with:

     mysqladmin -h hostname flush-privileges 

   or with the SQL command:

     FLUSH PRIVILEGES

-- 
Henry Hartley