Managing MySQL databases

MYSQL_getDatabases


                Input parameters:

                    - [search] : string : filter the list by database name.

                    - [orderArray] : OrderArray : results order structure.

                    

                Output parameters:

                    - Returns an ArrayOfMysqlInfo

                    - Or fault:

                        - ERROR_PROCESSOR_USERAUTH                        

                        - ERROR_PROCESSOR_PARAM_VALIDATION                                                                                                                        

                        - ERROR_MYSQL_GETMYSQLDBS

                        - ERROR_PROCESSOR_CONNECT_SYSTEM_DATABASE

                        

                Callable by: domain

                Necessary permissions: none

                Remarks:

                    - List the MySQL databases created for the domain accessing the web service.

                    - The results may be ordered by the following criteria:

                        - login : database name

                        - date : database creation date

                Examples:

                    .NET    Java    PHP

            

MYSQL_newDataBase


                Input parameters:

                    - [login] : string : name of database to be created

                    - password : string : password to be assigned to the database

                    

                Output parameters:

                    - Returns a boolean with true value if the database has been created correctly.

                    - Or fault:

                        - ERROR_PROCESSOR_USERAUTH                        

                        - ERROR_PROCESSOR_PARAM_VALIDATION                                                                                                                        

                        - ERROR_PROCESSOR_DOMAIN_LOCKED

                        - ERROR_MYSQL_NEWDATABASE

                        - ERROR_PROCESSOR_LIMIT_RESOURCES

                        - ERROR_MYSQL_DBNAMEEXISTS                        

                        - ERROR_PROCESSOR_CONNECT_SYSTEM_DATABASE

                        

                Callable by: domain

                Necessary permissions: PERM_DOMAIN_MYSQLDBS

                Remarks:

                    - Create a new MySQL database.

                    - If the login is null, an auto-generated sequential name will be assigned to the database.

                Examples:

                    .NET    Java    PHP

            

MYSQL_changePassword


                Input parameters:

                    - mysqlID : int : MySQL database ID

                    - newPassword : string : new password to be assigned to the database

                    

                Output parameters:

                    - Returns a boolean with true value if the password has been changed correctly

                    - Or fault:

                        - ERROR_PROCESSOR_USERAUTH                        

                        - ERROR_PROCESSOR_PARAM_VALIDATION                                                                                                                        

                        - ERROR_PROCESSOR_DOMAIN_LOCKED

                        - ERROR_MYSQL_MYSQLNOTEXISTS

                        - ERROR_MYSQL_CHANGEPASSWORD                        

                        - ERROR_PROCESSOR_CONNECT_SYSTEM_DATABASE

                        

                Callable by: domain

                Necessary permissions: PERM_DOMAIN_MYSQLDBS

                Remarks:

                    - Assigns a new password to a database                    

                Examples:

                    .NET    Java    PHP

            

MYSQL_delDataBase


                Input parameters:

                    - arrayId : Array : array of MySQL database IDs.

                    

                Output parameters:

                    - Return a boolean with true value if the databases have been deleted correctly.

                    - Or fault:

                        - ERROR_PROCESSOR_USERAUTH                        

                        - ERROR_PROCESSOR_PARAM_VALIDATION                                                                                                                        

                        - ERROR_PROCESSOR_DOMAIN_LOCKED

                        - ERROR_MYSQL_MYSQLNOTEXISTS

                        - ERROR_MYSQL_DELDATABASE                        

                        - ERROR_PROCESSOR_CONNECT_SYSTEM_DATABASE

                        

                Callable by: domain

                Necessary permissions: none

                Remarks:

                    - Deletes the MySQL databases indicated in the array arrayId.

                Examples:

                    .NET    Java    PHP