0

I have mysql-Calpont installed in a Linux machine. When i try to start mysql-Calpont, it gives an error: Starting MySQL. ERROR! Manager of pid-file quit without updating file.

Totally new to Linux. Need help to figure out why this is happening and how to get mysql started.

Thanks

WinSupp
  • 361
  • 2
  • 6
  • 20
  • Please share the last lines of the mysql log which will contain the error – Antonios Jul 17 '14 at 14:38
  • @Antonis -- The log-bin was commented out from the my.cnf file, so I guess there was not log created. I enabled this tag and entered the name and path of the log file.. but it did not create any log file... Am I doing the right thing to create a log or looking at the wrong log file? – WinSupp Jul 17 '14 at 14:40
  • not bin-log (which is binary log) i mean the log-error variable – Antonios Jul 17 '14 at 14:46
  • This is what the log says: **140717 10:49:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/Calpont/mysql/db 140717 10:49:18 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 140717 10:49:18 [ERROR] Aborting 140717 10:49:18 [Note] /usr/local/Calpont/mysql/libexec/mysqld: Shutdown complete 140717 10:49:18 mysqld_safe mysqld from pid file /usr/local/Calpont/mysql/db/optimus.pid ended** – WinSupp Jul 17 '14 at 14:50
  • Execute as root: groupadd mysql useradd -r -g mysql mysql – Antonios Jul 17 '14 at 14:51
  • Then retry to start mysql – Antonios Jul 17 '14 at 14:53

1 Answers1

0

Seems like mysql user is missing. Please execute as root:
groupadd mysql
useradd -r -g mysql mysql

Antonios
  • 190
  • 8