Upset because there is no help from the related answer I found here. The version of mysql on my host is 5.6.14-1.
The error occured when I start the server as below. Sorry for I can't show the hostname because it's owned by company.
sudo /etc/init.d/mysql start Starting MySQL..The server quit without updating PID file ([FAILED]/mysql/<<hostname>>.pid).
And the error message from /var/lib/mysql/<<\hostname>>.err
131213 16:36:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-12-13 16:36:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 16:36:05 18974 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 2013-12-13 16:36:05 18974 [ERROR] Aborting 2013-12-13 16:36:05 18974 [Note] Binlog end 2013-12-13 16:36:05 18974 [Note] /usr/sbin/mysqld: Shutdown complete 131213 16:36:05 mysqld_safe mysqld from pid file /var/lib/mysql/<<hostname>>.pid ended
I haven't had a user name 'mysql', actually I just have only one user 'root'. I don't have a good knowledge about mySql. Could anyone help with it? Thanks in advance.