ispCP 1.0.6 to i-mscp but no root SQL password

**TechnikOnkel** · Oct 21st 2012

Hello everybody!

i have a i-scpCP 1.0.6 Installation running on a physical Ubuntu Server.
Is there a easy possibility to migrate this machine to the new i-msCP without having the root SQL password of the old machine? I just have to admin and reseller of i-isCP and the Server password.

I have not documented the password a few years ago.

Thanks

**joximu** · Oct 22nd 2012

You should be able to retrieve the SQL password given (its stored encrypted - but not as hash).

Or you can change the password (an/or username) for the mysql acccess - there's a docu in the wiki (should...)

to retrieve you need something like this

PHP

#!/usr/bin/php -q
<?php
$cut='/usr/bin/cut';
$grep='/bin/grep';
ini_set('include_path', '.:/usr/share/php:/usr/share/pear:/var/www/imscp/gui/library/');
require '/var/www/imscp/gui/library/imscp-lib.php';
$icnf = '/etc/imscp/imscp.conf';
$IUSR= exec("$grep ^DATABASE_USER $icnf | $cut -f2 -d'=' | $cut -f2 -d' '");
$IPW = exec("$grep ^DATABASE_PASSWORD $icnf | $cut -f2 -d'=' | $cut -f2 -d' '");
echo decrypt_db_password($IPW);
printf ("\n");

Display More

hope it's correct...

/J

**MasterTH** · Dec 26th 2012

if you have ispcp running and updated from earlier versions there could be a lot of problems with the database.

Upgrade to 1.0.7 at first, fix the errors. Then try to migrate.

ispCP 1.0.6 to i-mscp but no root SQL password

Share

Similar Threads

MySQL root user is deleted

Daily visitors