Question

MYSQL ERROR , can not start MYSQL Ubuntu 16.04

Hi,

Can someone pls help me with MYSL error, I ca not start MYSQL server on Ubuntu ! This is the error from the console :

https://ibb.co/hVNNzNW

some sylog file :

May 11 14:32:25 box systemd[1]: Started User Manager for UID 0.
May 11 14:33:04 box systemd[1]: proc-sys-fs-binfmt_misc.automount: Got automount request for /proc/sys/fs/binfmt_misc, triggered by 2115 (find)
May 11 14:33:04 box systemd[1]: Mounting Arbitrary Executable File Formats File System...
May 11 14:33:04 box systemd[1]: Mounted Arbitrary Executable File Formats File System.
May 11 14:34:09 box systemd[1]: Started Session 3 of user root.
May 11 14:35:00 box systemd[1]: Started Session 4 of user root.
May 11 14:36:51 box systemd[1]: Starting Cleanup of Temporary Directories...
May 11 14:36:51 box systemd-tmpfiles[2314]: [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path "/var/log", ignoring.
May 11 14:36:51 box systemd[1]: Started Cleanup of Temporary Directories.
May 11 14:39:01 box CRON[2345]: (root) CMD (  [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
May 11 14:40:39 box systemd[1]: Started Session 6 of user root.
May 11 14:42:41 box systemd[1]: Starting MySQL Community Server...
May 11 14:42:41 box systemd[2487]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:42:41 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:42:41 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:42:41 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:42:41 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:42:42 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:42:42 box systemd[1]: Stopped MySQL Community Server.
May 11 14:42:42 box systemd[1]: Starting MySQL Community Server...
May 11 14:42:42 box systemd[2492]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:42:42 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:42:42 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:42:42 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:42:42 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:42:42 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:42:42 box systemd[1]: Stopped MySQL Community Server.
May 11 14:42:42 box systemd[1]: Starting MySQL Community Server...
May 11 14:42:42 box systemd[2495]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:42:42 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:42:42 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:42:42 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:42:42 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:42:42 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:42:42 box systemd[1]: Stopped MySQL Community Server.
May 11 14:42:42 box systemd[1]: Starting MySQL Community Server...
May 11 14:42:42 box systemd[2498]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:42:42 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:42:42 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:42:42 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:42:42 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:42:42 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:42:42 box systemd[1]: Stopped MySQL Community Server.
May 11 14:42:42 box systemd[1]: Starting MySQL Community Server...
May 11 14:42:42 box systemd[2501]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:42:42 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:42:42 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:42:42 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:42:42 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:42:43 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:42:43 box systemd[1]: Stopped MySQL Community Server.
May 11 14:42:43 box systemd[1]: mysql.service: Start request repeated too quickly.
May 11 14:42:43 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:42:43 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:42:43 box systemd[1]: mysql.service: Failed with result 'start-limit-hit'.
May 11 14:43:49 box systemd[1]: Starting MySQL Community Server...
May 11 14:43:49 box systemd[2526]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:43:49 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:43:49 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:43:49 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:43:49 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:43:50 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:43:50 box systemd[1]: Stopped MySQL Community Server.
May 11 14:43:50 box systemd[1]: Starting MySQL Community Server...
May 11 14:43:50 box systemd[2554]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:43:50 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:43:50 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:43:50 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:43:50 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:43:50 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:43:50 box systemd[1]: Stopped MySQL Community Server.
May 11 14:43:50 box systemd[1]: Starting MySQL Community Server...
May 11 14:43:50 box systemd[2557]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:43:50 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:43:50 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:43:50 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:43:50 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:43:50 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:43:50 box systemd[1]: Stopped MySQL Community Server.
May 11 14:43:50 box systemd[1]: Starting MySQL Community Server...
May 11 14:43:50 box systemd[2560]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:43:50 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:43:50 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:43:50 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:43:50 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:43:50 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:43:50 box systemd[1]: Stopped MySQL Community Server.
May 11 14:43:50 box systemd[1]: Starting MySQL Community Server...
May 11 14:43:50 box systemd[2563]: mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process
May 11 14:43:50 box systemd[1]: mysql.service: Control process exited, code=exited status=217
May 11 14:43:50 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:43:50 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:43:50 box systemd[1]: mysql.service: Failed with result 'exit-code'.
May 11 14:43:51 box systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
May 11 14:43:51 box systemd[1]: Stopped MySQL Community Server.
May 11 14:43:51 box systemd[1]: mysql.service: Start request repeated too quickly.
May 11 14:43:51 box systemd[1]: Failed to start MySQL Community Server.
May 11 14:43:51 box systemd[1]: mysql.service: Unit entered failed state.
May 11 14:43:51 box systemd[1]: mysql.service: Failed with result 'start-limit-hit'.
May 11 14:44:57 box systemd[1]: Started Session 7 of user root.
May 11 14:57:29 box systemd[1]: Started Session 8 of user root.

any help pls?


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

The problem is the following line from your error log:


mysql.service: Failed at step USER spawning /usr/share/mysql/mysql-systemd-start: No such process

This is usually related to quoting a user name in your service file. It would be something like :

[Service]
User="UserName"

Once you remove it and restart MySQL it would start.

If it still doesn’t start can you provide us with the output of journalctl -xe | tail -50 to your next reply?