Accessing expands mysql database

From Ezee.co.uk

[edit] How to get the expand mysql password

Log into the expand server as root.

View the file

vi /usr/local/expand/conf/expand.conf

there is a section called Database settings All information is here.

You can then either use mysql directly as normal or use piped commands such as

echo "name from plesk_domain" | mysql -u expand -pxxxpasswdzzz expand >expand.txt