MySQL #2002 - No such file or directory
Ignatios Athanasiadis
ignathanas at gmail.com
Tue Sep 6 08:19:30 PDT 2016
A thing I did not mention,
When I hit:
sudo -u _mysql mysql_install_db
I receive the following error:
sudo -u _mysql mysql_install_db
Installing MySQL system tables...2016-09-06 16:03:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-09-06 16:03:05 0 [Note] /opt/local/lib/mysql56/bin/mysqld (mysqld 5.6.32) starting as process 2228 ...
2016-09-06 16:03:05 2228 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-09-06 16:03:05 2228 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-06 16:03:05 2228 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-06 16:03:05 2228 [Note] InnoDB: Memory barrier is not used
2016-09-06 16:03:05 2228 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-09-06 16:03:05 2228 [Note] InnoDB: Using CPU crc32 instructions
2016-09-06 16:03:05 2228 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-09-06 16:03:05 2228 [Note] InnoDB: Completed initialization of buffer pool
2016-09-06 16:03:05 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:05 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:05 2228 [Note] InnoDB: Retrying to lock the first data file
2016-09-06 16:03:06 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:06 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:07 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:07 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:08 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:08 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:09 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:09 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:10 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:10 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:11 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:11 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:12 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:12 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:13 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:13 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:14 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:14 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:15 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:15 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:16 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:16 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:17 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:17 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:18 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:18 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:19 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:19 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:20 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:20 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:21 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:21 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:22 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:22 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:23 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:23 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:24 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:24 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:25 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:25 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:26 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:26 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:27 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:27 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:28 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:28 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:29 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:29 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:30 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:30 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:31 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:31 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:32 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:32 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:33 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:33 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:34 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:34 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:35 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:35 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:36 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:36 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:37 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:37 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:38 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:38 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:39 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:39 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:40 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:40 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:41 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:41 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:42 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:42 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:43 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:43 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:44 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:44 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:45 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:45 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:46 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:46 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:47 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:47 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:48 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:48 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:49 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:49 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:50 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:50 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:51 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:51 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:52 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:52 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:53 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:53 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:54 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:54 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:55 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:55 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:56 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:56 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:57 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:57 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:58 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:58 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:03:59 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:03:59 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:00 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:00 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:01 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:01 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:02 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:02 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:03 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:03 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:04 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:04 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:05 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:05 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:06 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:06 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:07 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:07 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:08 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:08 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:09 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:09 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:10 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:10 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:11 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:11 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:12 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:12 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:13 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:13 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:14 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:14 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:15 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:15 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:16 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:16 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:17 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:17 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:18 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:18 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:19 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:19 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:20 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:20 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:21 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:21 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:22 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:22 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:23 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:23 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:24 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:24 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:25 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:25 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:26 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:26 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:27 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:27 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:28 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:28 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:29 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:29 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:30 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:30 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:31 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:31 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:32 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:32 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:33 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:33 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:34 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:34 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:35 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:35 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:36 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:36 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:37 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:37 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:38 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:38 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:39 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:39 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:40 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:40 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:41 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:41 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:42 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:42 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:43 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:43 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:44 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:44 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:45 2228 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-09-06 16:04:45 2228 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-06 16:04:45 2228 [Note] InnoDB: Unable to open the first data file
2016-09-06 16:04:45 7fff78dc1000 InnoDB: Operating system error number 35 in a file operation.
InnoDB: Error number 35 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-09-06 16:04:45 2228 [ERROR] InnoDB: Can't open './ibdata1'
2016-09-06 16:04:45 2228 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to 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!
2016-09-06 16:04:45 2228 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-06 16:04:45 2228 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-06 16:04:45 2228 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-06 16:04:45 2228 [ERROR] Aborting
2016-09-06 16:04:45 2228 [Note] Binlog end
2016-09-06 16:04:45 2228 [Note] /opt/local/lib/mysql56/bin/mysqld: Shutdown complete
> On 6 Sep 2016, at 14:33, Ignatios Athanasiadis <ignathanas at gmail.com> wrote:
>
> Hi all,
>
> I have followed the links below to generate a phpmyadmin server and link it to mysql.
>
> https://trac.macports.org/wiki/howto/Apache2
> https://trac.macports.org/wiki/howto/MySQL
> https://trac.macports.org/wiki/howto/PHP
> https://trac.macports.org/wiki/howto/MAMP
>
> and https://coolestguidesontheplanet.com/get-apache-mysql-php-and-phpmyadmin-working-on-osx-10-11-el-capitan/
>
> However I am getting the error :
> #2002 - No such file or directory — The server is not responding (or the local server's socket is not correctly configured).
>
> As stated in the last link I try to make a link to mysql.sock as:
> sudo mkdir /var/mysql
> sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
> However, there is no file mysql.sock in /tmp/.
>
> Do you have any suggestions?
> Thank you very much in advance.
>
> Ignatios
>
More information about the macports-users
mailing list