Can't Start MySQL

[G3z]

Please fill out the detail below, it helps me investigate the bug: When i create a mysql instance it can't stay up

this is what i found in system.log

Oct 29 17:27:54 JBook com.apple.xpc.launchd[1] (com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F): This service is defined to be constantly running and is inherently inefficient.
Oct 29 17:27:54 JBook com.apple.xpc.launchd[1] (com.apple.xpc.launchd.user.domain.502.100009.Aqua): com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F (lint): UserName is not supported for non-System services.
Oct 29 17:27:54 JBook com.apple.xpc.launchd[1] (com.apple.xpc.launchd.user.domain.502.100009.Aqua): com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F (lint): GroupName is not supported for non-System services.
Oct 29 17:27:55 JBook com.apple.xpc.launchd[1] (com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F[12680]): Service exited with abnormal code: 3
Oct 29 17:27:55 JBook com.apple.xpc.launchd[1] (com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F): Service only ran for 0 seconds. Pushing respawn out by 10 seconds.


Oct 29 17:28:06 JBook com.apple.xpc.launchd[1] (com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F[12684]): Service exited with abnormal code: 3
Oct 29 17:28:06 JBook com.apple.xpc.launchd[1] (com.tinyapp.DBngin.mysqld-947A779E-53E8-4BDA-B81D-35AC0F03374F): Service only ran for 0 seconds. Pushing respawn out by 10 seconds.

1. Driver (Ex: PostgreSQL 10.0): Mysql 5.7
2. DBngin build number: 1.0 14
3. macOS version: 10.14
4. The steps to reproduce this issue: Create a new mysql and start it

this is mysql error log

2018-10-29T16:36:43.614535Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-10-29T16:36:43.614911Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-10-29T16:36:43.614960Z 0 [Note] /Users/Shared/DBngin/mysql/5.7.23/bin/mysqld (mysqld 5.7.23) starting as process 13362 ...
2018-10-29T16:36:43.617878Z 0 [Warning] Setting lower_case_table_names=2 because file system for /Users/g3z/Library/Application Support/com.tinyapp.DBngin/Engines/mysql/947A779E-53E8-4BDA-B81D-35AC0F03374F/ is case insensitive
2018-10-29T16:36:43.618573Z 0 [Warning] One can only use the --user switch if running as root

2018-10-29T16:36:43.618982Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2018-10-29T16:36:43.657953Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-10-29T16:36:43.657991Z 0 [Note] InnoDB: Uses event mutexes
2018-10-29T16:36:43.658003Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-10-29T16:36:43.658013Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-29T16:36:43.658424Z 0 [Note] InnoDB: Number of pools: 1
2018-10-29T16:36:43.658571Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-10-29T16:36:43.660082Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-10-29T16:36:43.819180Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-10-29T16:36:43.858593Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2018-10-29T16:36:43.863220Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2018-10-29T16:36:43.863264Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2018-10-29T16:36:43.863282Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2018-10-29T16:36:43.863299Z 0 [ERROR] InnoDB: File /usr/local/mysql/data/ibdata1: 'create' returned OS error 71. Cannot continue operation
2018-10-29T16:36:43.863313Z 0 [ERROR] InnoDB: Cannot continue operation.

[huyphams]

Thanks @G3z let me see if I can reproduce the bug.