Koozali.org: home of the SME Server

Lost MySQL Password

Jon Thiele

Lost MySQL Password
« 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???

John Lewis

Re: Lost MySQL Password
« Reply #1 on: September 26, 2001, 05:51:38 PM »