You should keep the following issues and notes in mind:
As of MySQL server 5.6.26, the DMG bundles a launchd daemon instead of the deprecated startup item. Startup items do not function as of macOS 10.10 (Yosemite), so using launchd is preferred. The available MySQL preference pane under macOS System Preferences was also updated to use launchd.
You may need (or want) to create a specific
mysqluser to own the MySQL directory and data. You can do this through the Directory Utility, and the
mysqluser should already exist. For use in single user mode, an entry for
_mysql(note the underscore prefix) should already exist within the system
Because the MySQL package installer installs the MySQL contents into a version and platform specific directory, you can use this to upgrade and migrate your database between versions. You must either copy the
datadirectory from the old version to the new version, or alternatively specify an alternative
datadirvalue to set location of the data directory. By default, the MySQL directories are installed under
You might want to add aliases to your shell's resource file to make it easier to access commonly used programs such as mysql and mysqladmin from the command line. The syntax for bash is:
alias mysql=/usr/local/mysql/bin/mysql alias mysqladmin=/usr/local/mysql/bin/mysqladmin
For tcsh, use:
alias mysql /usr/local/mysql/bin/mysql alias mysqladmin /usr/local/mysql/bin/mysqladmin
Even better, add
PATHenvironment variable. You can do this by modifying the appropriate startup file for your shell. For more information, see Invoking MySQL Programs.
After you have copied over the MySQL database files from the previous installation and have successfully started the new server, you should consider removing the old installation files to save disk space. Additionally, you should also remove older versions of the Package Receipt directories located in