¡Esta es una revisión vieja del documento!

Convertir timestamp a fecha legible

  SELECT *,DATE_FORMAT(FROM_UNIXTIME(`log_timestamp`), '%d/%m/%Y %H:%m:%s') AS 'date_formatted'
  FROM process_log
  

Crear usuario linux

sudo mysql
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

conectarse

mysql -u admin -P 23306 -h localhost --protocol=tcp -p