Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Jon Thiele on September 26, 2001, 07:44:55 AM

Title: Lost MySQL Password
Post by: Jon Thiele on September 26, 2001, 07:44:55 AM

Upgrading from eesg4.1.2 to SME5.0 changes the root password in MySQL from a 7 digit field to some huge 75 character field.  Since I run a MySQL database in an Ibay, I had to change this password im a couple of my scripts.  (Yes, I *now* know I should not run MySQL as the MySQL root user...)

Instead of changing the scripts, I thought I would change the password - and of course messed it up.  I now don't know what my root password is for MySQL.  

According to this page http://www.mysql.com/doc/A/c/Access_denied.html "If you have forgot the root password, you can restart mysqld with --skip-grant-tables to change the password."

Ummmm, O.K., any hints on how to go about this???

Title: Re: Lost MySQL Password
Post by: John Lewis on September 26, 2001, 05:51:38 PM

See this thread:

http://forums.contribs.org/index.php?topic=11516.msg43320#msg43320