¡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;