Can't start mysqld after upgrade from 5.5 to 5.6 (Mac OS X Server)

[Rob Lewis]

I thought I had a permissions issue, but now I don't know. Here's what I get when I try to start mysqld:



2016-08-15 15:28:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-15 15:28:06 0 [Note] mysqld (mysqld 5.6.32-log) starting as process 59584 ...
2016-08-15 15:28:06 59584 [Warning] Can't create test file /usr/local/mysql-5.6.32-osx10.11-x86_64/data/froghill.lower-test
2016-08-15 15:28:06 59584 [Warning] Can't create test file /usr/local/mysql-5.6.32-osx10.11-x86_64/data/froghill.lower-test
2016-08-15 15:28:06 59584 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=froghill-bin' to avoid this problem.
mysqld: File './froghill-bin.index' not found (Errcode: 13 - Permission denied)
2016-08-15 15:28:06 59584 [ERROR] Aborting

2016-08-15 15:28:06 59584 [Note] Binlog end
2016-08-15 15:28:06 59584 [Note] mysqld: Shutdown complete


I added this line to my.cnf:
log_bin = froghill-bin

and, in desperation:
datadir = /usr/local/mysql/data

Now I get the following, with the "unable to lock" message repeated apparently forever:

2016-08-15 19:10:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-15 19:10:27 0 [Note] mysqld (mysqld 5.6.32-log) starting as process 74945 ...
2016-08-15 19:10:27 74945 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
2016-08-15 19:10:27 74945 [Note] Plugin 'FEDERATED' is disabled.
2016-08-15 19:10:27 74945 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-15 19:10:27 74945 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-15 19:10:27 74945 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-15 19:10:27 74945 [Note] InnoDB: Memory barrier is not used
2016-08-15 19:10:27 74945 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-15 19:10:27 74945 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-15 19:10:27 74945 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2016-08-15 19:10:27 74945 [Note] InnoDB: Completed initialization of buffer pool
2016-08-15 19:10:27 74945 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-08-15 19:10:27 74945 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-08-15 19:10:27 74945 [Note] InnoDB: Retrying to lock the first data file
2016-08-15 19:10:28 74945 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-08-15 19:10:28 74945 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-08-15 19:10:29 74945 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2016-08-15 19:10:29 74945 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.