// Utente DB su dev:
user: dbtech
pwd: dbtc3281
host: [host del cloud]
db: dbtech
Permessi su tabella dbtech: SELECT, INSERT, UPDATE, DELETE
Permessi globali: USAGE
GRANT SELECT,INSERT,UPDATE,DELETE on dbtech.* to 'dbtech'@'[ip cloud hosting]' identified by 'dbtc3281';



// Utente DB locale
user: dbtech
pwd: dbt651
host: [host del cloud]
Permessi su tabella mysql: SELECT
Permessi globali: SHOW DATABASES, SHOW VIEW

CREATE USER 'dbtech'@'[ip cloud hosting]' IDENTIFIED BY 'dbt651';
GRANT SHOW DATABASES ON *.* TO 'dbtech'@'[ip cloud hosting]';
GRANT SHOW VIEW ON *.* TO 'dbtech'@'[ip cloud hosting]';
GRANT SELECT ON `mysql`.* TO 'dbtech'@'[ip cloud hosting]';
FLUSH PRIVILEGES;



*/5 * * * * php /path/to/dbtech/check.php
30 0 * * * php /path/to/dbtech/check.php -all



cd ..
mkdir dbtech
cd dbtech/
svn co http://dev.neikos.it/svn/dbtech/__server_scripts/cloud_hosting/ .