The file system shows there is a user, "_mysql", that I cannot "su" as root. What is basically going on so I can get mysqld running again
My mysql database (5.6.23) became unable to start when I upgraded from El Capitan to Catalina (10.15.5). Now it works. This is what I did, but its possible some of this might not be needed or a recommended thing to do:

/tmp$ su
Password:
/tmp# cd /usr/local/mysql/data
/usr/local/mysql/data# chown _mysql:_mysql *
/usr/local/mysql/data# chmod 777 *
/usr/local/mysql/data# exit
/usr/local/mysql/data$ cd /tmp
/tmp$ sudo /usr/local/mysql/support-files/mysql.server start &amp;

One major error was that &quot;/usr/local/mysql/data/JonDoe-MacBook-Pro.local.pid could not be created&quot;. And that was resolved by the chown and chmod commands I think. Before the chown, the user was root and group was wheel for files, but not directories, in /usr/local/mysql/data.
(#1) this does not start the server

/tmp$ su
Password:
/tmp# cd /usr/local/mysql/support-files
/usr/local/mysql/support-files# ./mysql.server start &amp;

(#2) this does the server

/tmp$ sudo /usr/local/mysql/support-files/mysql.server start &amp;

My understanding is that option #1 and #2 should start the server in the exact same way. This added to my not understanding.