Commando's

SELECT name, mail, DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(login),'UTC','+00:00'), '%d/%m/%Y %H:%i:%s') AS 'last_login' FROM `users_field_data` ORDER BY login DESC;

mysqldump -u [user name] –p [password] [options] [database_name] [tablename] > [dumpfilename.sql]
mysqldump -u user_name -p database_name > backup.sql
ssh sshuser@sshhost "mysqldump -u user_name -p database_name | gzip -9" > dbbackup.sql.gz

SET GLOBAL default_password_lifetime = 0;
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
UPDATE mysql.user SET Password=PASSWORD('Br@nd00zl3d') WHERE User='root';
SET PASSWORD = PASSWORD('Br@nd00zl3d');
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Br@nd00zl3d';