Problem w/ MySQL57 install

[Bradley Giesbrecht]

> On Jul 25, 2016, at 12:04 AM, Bill Christensen <billc_lists at greenbuilder.com> wrote:
> 
> Hi folks,
> 
> in the instructions at https://trac.macports.org/wiki/howto/MySQL (written to MySQL56, though I'm using the same instructions to install MySQL57 instead), it says to run
> 
>       sudo -u _mysql mysql_install_db
> 
> Doing so for MySQL57 gives the message:
> 
>      [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
> 
> I tried
> 
>     sudo -u _mysql mysqld --initialize
> 
> but that gave me 
> 
>     [ERROR] --initialize specified but the data directory has files in it. Aborting.
> 
> which appears to be true.... Is there a different command I should be using, or are there some missing options which need to be specified?
> 
> When I load MySQL and try to connect I get
> 
>      Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2)

If the mysql.sock file does not exist and mysql57 is running then there is likely a my.cnf options file in one of the paths that mysql searches.

http://dev.mysql.com/doc/refman/5.7/en/option-files.html

Rename or delete the options file if found.


—
Brad