mysql8 8.4.8 Port notes lack crucial macports-specific steps before start server

[robcd (Rob Dickens)]

§2.2 of the Mysql reference manual has generic instructions, but being spoon-fed the following would have saved me a lot of time spent investigating socket-file-related errors.

  ~ % cd /opt/local/var/run
run % sudo mkdir mysql8
run % sudo chown mysql mysql8

Then do the following (based on §2.2), to initialise the data directory, and start the server:

run % cd ../db
 db % sudo mkdir mysql8-files
 db % sudo chown mysql:mysql mysql8-files
 db % sudo chmod 750 mysql8-files
 db % sudo mysqld --initialize --user=mysql
 db % sudo mysqld_safe --user=mysql