MySQL 8: datadir

[Ryan Schmidt]

On Oct 2, 2020, at 19:36, Murray Eisenberg wrote:

> Assuming I do _not_ want to initialize the database, given that I want to use an existing (MySQL 5.7) database with the newly installed MySQL8, I loaded mysql8-server, then tried to connect to it:
> 
> 		mysql
> 	ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2)
> 
> Note:
> 
> 		sudo port select --show mysql
> 	The currently selected version for 'mysql' is 'mysql8’.
> 
> So the error from trying to execute ‘mysql’ is surprising! Here’s my configuration file /opt/local/etc/mysql8/my.cnf :
> 
> 	# Use default MacPorts settings
> 	!include /opt/local/etc/mysql8/macports-default.cnf
> 
> 	[mysqld]
> 		datadir = /Users/murray/Databases/mysql/data
> 	port = 3306
> 	socket = /opt/local/var/run/mysql8/mysqld.sock
> 	pid-file = /opt/local/var/run/mysqld/mysqld.pid
> 
> 	sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
> 
> 	[client]
> 	socket = /opt/local/var/run/mysql8/mysqld.sock
> 
> What’s wrong??

I'm not sure. Your questions are probably not specific to MacPorts; they're more MySQL-specific, so you might have more luck asking in a MySQL support venue.

What does "which mysql" say? What about "mysql --version"?

Could there be a my.cnf file in /Users/murray/Databases/mysql/data that's overriding your settings?