T06:52:45.557302Z 0 -initialize specified but the data directory has files in it. Initialize fails sudo -u mysql /opt/local/lib/mysql8/bin/mysqld -initialize -user=_mysql Phobos:8-server wf$ls -l /opt/local/var/db/mysql8 Starting and stopping the MySQL server Start $ sudo port load mysql8-server With disabled networking it is possible to install and have running all the MacPorts mysql ports simultaneously. Currently /opt/local/etc/mysql8/macports-default.cnf contains only one directive to disable networking. On activation if no /opt/local/etc/mysql8/my.cnf file exists one will be created which loads /opt/local/etc/mysql8/macports-default.cnf.Īny changes made to /opt/local/etc/mysql8/macports-default.cnf will be lost during port upgrades, deactivations or activations. opt/local/etc/mysql8/my.cnf is a good place to customize your mysql8 installation. Sudo /opt/local/lib/mysql8/bin/mysql_upgrade -u root -p Man mysql_upgrade - details on the upgrade program (man page) If the database exists from a previous installation, you may need to upgrade. See also Step 6: Database upgrade as necessary There is an interactive program to secure a MySQL installation.

If desired, reboot your machine and then run:Īgain to verify that the daemon is again running. Once you are logged in, simply exit the session like this: It means you have entered the wrong password. Test everything by logging in to the server.ĮRROR 1045 (28000): Access denied for user (using password: YES) Then `is your new desired root password, followed by Return. You will first be prompted for your existing password ( Enter password:) enter the root password (auto generated or no entry depending on your MySQL version) then press Return. Booting fails and you need the error log.Step 5: Optional security configuration.

Mac install mysql server