# create user
CREATE USER 'cdt_timecontroling'@'localhost' IDENTIFIED BY 'FZ4pMpbPQ7st8yTY';

GRANT ALL PRIVILEGES ON cdt_timecontroling.* TO 'cdt_timecontroling'@'localhost';

FLUSH PRIVILEGES;

CREATE USER 'powerbi_user'@'%' IDENTIFIED BY '34DEferEO456NU9';

GRANT SELECT ON cdt_timecontroling.* TO 'powerbi_user'@'%';

FLUSH PRIVILEGES;

SERVER: 45.7.231.35


SELECT * 
FROM timecontrollings
ORDER BY fecha DESC
LIMIT 10;

# importar base de datos

mysql -u root  cdt_timecontroling < /var/www/backend/timecontrolling/sql/backup_sql/cdt_timecontroling.sql
