If you ever loose your mysql root password (remember is not the same as the system root password) you can recover it following this steps,
But before those steps, i should say that i put them in a program at www.ehcp.net/other/resetmysqlrootpass.sh.txt
You may download that prog and run on your server, or you may directly run that in your ehcp dir.
Here are manual steps:
first, stop your mysql, by
/etc/init.d/mysql stop
then,
Start MySQL in safe mode
mysqld_safe --skip-grant-tables &
Enter the console as root
mysql -u root
Set the new password
UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
Update the privileges
FLUSH PRIVILEGES;
After this, you may use your new_password... for ehcp install or anything..
note that, ehcp asks for your mysql root password to install its mysql data..


Recent comments
7 hours 27 min ago
1 day 1 hour ago
1 day 2 hours ago
1 day 3 hours ago
1 day 4 hours ago
1 day 8 hours ago
1 day 12 hours ago
2 days 20 hours ago
3 days 3 hours ago
3 days 14 hours ago