Failed to start mysql after moving to new partition

Posting this as an answer.

It was a file permissions issue. U need to ensure that the mysql user has access to the mysql datadir and the directory it is in, all the way to the root level directory.

If multiple users need access to these directories, then put them in a group and then give that group access to those directories.


Why don't you just put the ZFS dataset in the location MySQL expects?

zfs set mountpoint=/var/lib/mysql tank/mysql

Now you don't have to worry about strange permissions on /tank and everything looks normal to the rest of the system.