Plesk FTPパスワードを調べる の変更点
*Plesk FTPパスワードを調べる [#y8873c49]
[[dokuwiki.fl8.jp転載済み>http://dokuwiki.fl8.jp/doku.php/parallels/plesk_ftp%E3%83%91%E3%82%B9%E3%83%AF%E3%83%BC%E3%83%89]]
[[dokuwiki.fl8.jp転載済み>http://dokuwiki.fl8.jp/doku.php/parallels/01_plesk/05_plesk_ftp%E3%83%91%E3%82%B9%E3%83%AF%E3%83%BC%E3%83%89]]
SELECT domains.name, sys_users.login, accounts.password, sys_users.home, sys_users.shell FROM domains
RIGHT JOIN hosting ON domains.id = hosting.dom_id
LEFT JOIN sys_users ON hosting.sys_user_id = sys_users.id
LEFT JOIN accounts ON sys_users.account_id = accounts.id
ORDER BY domains.name;
