Follow the steps below if you want to reset MySQL root password using Ensim.
1. Login to Ensim control panel as administrator.
2. Click on MySQL (under WebServer category) –> Change MySQL password.
3. Enter new password under “Change MySQL root Password”
Try logging into MySQL after changing the password. If you are uanble to login using the new password, please check the box “Force Password Change” before clicking on “save” button.
Regards,
Mohammed.










Instead of current MySQL root password reset we can find out existing root password using the following scripts.
# ensim-python -c “import sys;sys.path.append(\”/usr/lib/opcenter/mysql\”);import mysqlbe;print mysqlbe.read_mysqlpass()”
or
# ensim-python -c “from vh3 import virthost; from vh3.modules import mysql; print mysql.GetMySQLRootPass()”
Yes BC, It’s already here.
http://mohammednv.wordpress.com/2008/01/06/mysql-root-passwords-on-ensim-servers/
Anyway, thanks for your tip