title: Unable to start MySQL server - Control process exited with error code
body: <p>My mysql server is not starting after stopping it</p>
  <p>Command using:</p>
  <pre><code>sudo /etc/init.d/mysql restart
  </code></pre>
  <p>Error :</p>
  <blockquote>
  <p>Restarting mysql (via systemctl): mysql.serviceJob for mysql.service
  failed because the control process exited with error code.</p>
  </blockquote>
  <p>Checked status using <code>systemctl status mysql.service</code> and <code>journalctl -xe</code>, did not get any help.</p>
  <p>Error log:</p>
  <p>-</p>
  <blockquote>
  <pre><code>2020-06-23T00:11:48.882919Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use
  </code></pre>
  <p>--explicit_defaults_for_timestamp server option (see documentation for more details).</p>
  <pre><code>2020-06-23T00:11:48.883135Z 0 [Warning] Can't create test file /u1/mysql/sad-swh.lower-test
  
  2020-06-23T00:11:48.883185Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30-0ubuntu0.18.04.1) starting as process 28411 ...
  
  2020-06-23T00:11:48.886131Z 0 [Warning] Can't create test file /u1/mysql/sad-swh.lower-test
  
  2020-06-23T00:11:48.886148Z 0 [Warning] Can't create test file /u1/mysql/sad-swh.lower-test
  
  2020-06-23T00:11:48.889591Z 0 [Note] InnoDB: PUNCH HOLE support available
  
  2020-06-23T00:11:48.889612Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  
  2020-06-23T00:11:48.889616Z 0 [Note] InnoDB: Uses event mutexes
  
  2020-06-23T00:11:48.889620Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  
  2020-06-23T00:11:48.889623Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
  
  2020-06-23T00:11:48.889627Z 0 [Note] InnoDB: Using Linux native AIO
  
  2020-06-23T00:11:48.889890Z 0 [Note] InnoDB: Number of pools: 1
  
  2020-06-23T00:11:48.890022Z 0 [Note] InnoDB: Using CPU crc32 instructions
  
  2020-06-23T00:11:48.892207Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  
  2020-06-23T00:11:48.900818Z 0 [Note] InnoDB: Completed initialization of buffer pool
  
  2020-06-23T00:11:48.903535Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be
  </code></pre>
  <p>changed. See the man page of setpriority().</p>
  <pre><code>2020-06-23T00:11:48.913543Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will
  </code></pre>
  <p>be created!</p>
  <pre><code>2020-06-23T00:11:48.913858Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
  
  2020-06-23T00:11:48.913871Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
  
  2020-06-23T00:11:48.913878Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
  
  2020-06-23T00:11:48.913883Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
  
  2020-06-23T00:11:48.913889Z 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
  
  2020-06-23T00:11:48.913896Z 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to
  </code></pre>
  <p>the system tablespace, and it failed here, you should now edit
  innodb_data_file_path in my.cnf back to what it was, and remove the
  new ibdata files InnoDB created in this failed attempt. InnoDB only
  wrote those files full of zeros, but did not yet use them in any way.
  But be careful: do not remove old data files which contain your
  precious data!</p>
  <pre><code>2020-06-23T00:11:48.913903Z 0 [ERROR] InnoDB: InnoDB Database creation was aborted with error Cannot open a file. You may need to
  </code></pre>
  <p>delete the ibdata1 file before trying to start up again.</p>
  <pre><code>2020-06-23T00:11:49.514733Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  
  2020-06-23T00:11:49.514763Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  
  2020-06-23T00:11:49.514773Z 0 [ERROR] Failed to initialize builtin plugins.
  
  2020-06-23T00:11:49.514779Z 0 [ERROR] Aborting
  
  2020-06-23T00:11:49.514817Z 0 [Note] Binlog end
  
  2020-06-23T00:11:49.514889Z 0 [Note] Shutting down plugin 'CSV'
  
  2020-06-23T00:11:49.515486Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
  </code></pre>
  </blockquote>
  <pre><code> ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service;
   enabled;
   vendor preset: enabled) Active: failed (Result: exit-code) since Mon 2020-06-22 16:07:36 CST;
   9min ago Process: 26756 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE) Process: 26737 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 18936 (code=exited, status=0/SUCCESS)
  </code></pre>