The existing password for the user account root has expired. Mysql_secure_installation: Using a password on the command line interface can be insecure.
Mysql_secure_installation -uroot -p"kq3K=JR8 GqZ" T04:54:07.457954Z 1 A temporary password is generated for kq3K=JR8 GqZ T04:54:07.366688Z 0 CA certificate ca.pem is self signed.
Table 'mysql.gtid_executed' cannot be opened. T04:54:07.224871Z 0 Gtid table is not ready to be used. T04:54:07.196824Z 0 No existing UUID has been found, so we assume that this is the first time that this server has been started. T04:54:07.132950Z 0 InnoDB: Creating foreign key constraint system tables. T04:54:06.542625Z 0 Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive Please use -explicit_defaults_for_timestamp server option (see documentation for more details). T04:54:06.526061Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Mv /usr/local/var/mysql /usr/local/var/mysql.bak Homebrew/homebrew-cask (git revision c9f62 last commit ) Homebrew/homebrew-core (git revision eeb08 last commit ) There is NO WARRANTY, to the extent permitted by law.
This is free software you are free to change and redistribute it. License GPLv3+: GNU GPL version 3 or later Mysql should now work and be running all the time as expected run the commands Brew suggests, add MySQL to launchctl so it automatically launches at startup.mysql_install_db -verbose -user=whoami -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql -tmpdir=/tmp.
sudo rm -rf /private/var/db/receipts/*mysql*īrew install MySQL per user Sedorner from this answer.edit /etc/hostconfig and remove the line MYSQLCOM=-YES.launchctl unload -w ~/Library/LaunchAgents/.sudo rm -rf /Library/PreferencePanes/My*.sudo rm -rf /Library/StartupItems/MySQLCOM.Here are detailed instructions combining getting rid of all MySQL from your Mac then installing it The Brew Way as Sedorner wrote above: Remove MySQL completely per The Tech Lab Remember to add a password for the root user. sudo rver start sudo chown -R mysql /usr/local/var/mysql/ Tells you when it finishes (my install took 10 minutes) sudo brew install mysql -with-embedded say done it gives you some idea of what's coming next sudo brew info mysql sudo brew install openssl sudo brew install cmake Edit 2018: you can't run brew as root anymore I like to run brew as root, but I don't think you have to. Do remove stuff in its own mysql directory. For example, don't delete stuff in a PHP install's directory.
Note that many programs have drivers for mysql which you do not want to remove.