Chris Walker's Blog

Note that this will also work in Plesk for *nix as well.

Assuming that you read my previous how to on getting passwords from plesk on windows to do an easier migration, this will also come in handy.Typically, when doing these migrations. I create the database via plesk, move the domain, and then spend time running a command similar to

Follow up:

Unfortunately, this can become quite tedious. Having had gone through the database looking for other passwords, now, I've found the database ones, and I get them in a nice list.

/path/to/mysql -u admin -p
use psa; select db_users.login, db_users.passwd, data_bases.name, domains.name from db_users, data_bases, domains where data_bases.id = db_users.db_id and domains.id = data_bases.dom_id and domains.name = 'DOMAIN NAME';

This will give you the names of the databases, and their full user and password. Simplicity.