Advanced Search

Return to Snippet

Revision: 19632
at October 27, 2009 14:05 by tobewan
Initial Code 
echo "SELECT REPLACE(sys_users.home,'/home/httpd/vhosts/','') AS domain,
sys_users.login,accounts.password FROM sys_users
LEFT JOIN accounts on sys_users.account_id=accounts.id
ORDER BY sys_users.home ASC;" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -t
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Get Plesk FTP account passwords w/o logging into MySQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, server

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL