MySQL 8: datadir

[Murray Eisenberg]

> On 3 Oct2020, at 8:00 AM,Andrew Udvare <audvare at gmail.com <mailto:audvare at gmail.com>> wrote:
> 
> Your client is trying to connect
> /opt/local/var/run/mysql57/mysqld.sock instead of
> /opt/local/var/run/mysql8/mysqld.sock . Your client is not finding the
> correct socket path in my.cnf. You can specify which socket to connect
> to manually:
> 
> mysql -S /opt/local/var/run/mysql8/mysqld.sock ...
> 
> If you are running mysql8, does /opt/local/var/run/mysql8/mysqld.sock
> exist? It may be that your my.cnf says to put it at the old path.

(a) No, there is no such file /opt/local/var/run/mysql8/mysql.sock ! 

After loading mysql8-server, the only files in  /opt/local/var/run/mysql8 are .turd_mysql8-server and  mysqld.pid.

How is that file created?

(b) Manually specifying the socket gives the same kind of error as before:

		sudo port load mysql8-server
	--->  Loading startupitem 'mysql8-server' for mysql8-server 

	mysql -S /opt/local/var/run/mysql8/mysqld.sock
	ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql8/mysqld.sock' (2)
---
Murray Eisenberg			murrayeisenberg at gmail.com
503 King Farm Blvd #101	Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20201003/183310b1/attachment.htm>