Advanced Search

Return to Snippet

Revision: 19740
at October 29, 2009 17:45 by tobewan
Initial Code 
SELECT domains.name AS domain_name,
data_bases.name AS database_name, db_users.login, accounts.password
FROM data_bases, db_users, domains, accounts
WHERE data_bases.dom_id = domains.id
AND db_users.db_id = data_bases.id
AND db_users.account_id = accounts.id
ORDER BY domain_name;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Find all databases and login credentials

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, database, server, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL