Download and install the MySQL Preference Pane (included in MySQL Mac OS X dmg file download). Open the preference pane and you will see it complains about missing path etc. If this dir does not exist, create it. Mkdir /usr/local/mysql Create a symblink to share in this dir. In addition to the core installation, the Package Installer also includes Chapter 3, Installing a MySQL Launch Daemon and Chapter 4, Installing and Using the MySQL Preference Pane, both of which simplify the management of your installation. If this or any answer has solved your question please consider accepting it by clicking the check-mark. This indicates to the wider community that you've found a solution and gives some reputation to both the answerer and yourself.
Mysql Preference Pane Mac Download Mac
![Pane Pane](/uploads/1/2/6/4/126469505/689555647.png)
2.4.2 Installing MySQL on macOS Using Native Packages
Double-click the MySQL.prefPane file to download the MySQL control panel. This will install your control panel into the System Preferences application. Ready to open MySQL? Just go to System Preferences on your computer. There you will click on the Other section. You should see the MySQL icon. Click on Start MySQL and you’re ready to go! Sudo launchctl load -F com.oracle.oss.mysql.mysqld.plist Now in the MySQL System Preferences Pane I see the two red indicators flashing momentarily green, so MySQL is at least being awakened but appears to be quickly dying.
The package is located inside a disk image (
.dmg
) file that you first need to mount by double-clicking its icon in the Finder. It should then mount the image and display its contents. Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on macOS Server), the preference pane, or mysqladmin shutdown on the command line.
To install MySQL using the package installer:
- Download the disk image (
.dmg
) file (the community version is available here) that contains the MySQL package installer. Double-click the file to mount the disk image and see its contents.Double-click the MySQL installer package from the disk. It is named according to the version of MySQL you have downloaded. For example, for MySQL server 8.0.24 it might be namedmysql-8.0.24-osx-
.10.13-x86_64
.pkg - The initial wizard introduction screen references the MySQL server version to install. Click to begin the installation.The MySQL community edition shows a copy of the relevant GNU General Public License. Click and then to continue.
- From the Installation Type page you can either click to execute the installation wizard using all defaults, click to alter which components to install (MySQL server, MySQL Test, Preference Pane, Launchd Support -- all but MySQL Test are enabled by default).Although the option is visible, the installation location cannot be changed.Figure 2.14 MySQL Package Installer Wizard: Installation TypeFigure 2.15 MySQL Package Installer Wizard: Customize
- Click to install MySQL Server. The installation process ends here if upgrading a current MySQL Server installation, otherwise follow the wizard's additional configuration steps for your new MySQL Server installation.
- After a successful new MySQL Server installation, complete the configuration steps by choosing the default encryption type for passwords, define the root password, and also enable (or disable) MySQL server at startup.
- The default MySQL 8.0 password mechanism is
caching_sha2_password
(Strong), and this step allows you to change it tomysql_native_password
(Legacy).Figure 2.16 MySQL Package Installer Wizard: Choose a Password Encryption TypeChoosing the legacy password mechanism alters the generated launchd file to set--default_authentication_plugin=mysql_native_password
underProgramArguments
. Choosing strong password encryption does not set--default_authentication_plugin
because the default MySQL Server value is used, which iscaching_sha2_password
. - Define a password for the root user, and also toggle whether MySQL Server should start after the configuration step is complete.Figure 2.17 MySQL Package Installer Wizard: Define Root Password
- Summary is the final step and references a successful and complete MySQL Server installation. the wizard.Figure 2.18 MySQL Package Installer Wizard: Summary
MySQL server is now installed. If you chose to not start MySQL, then use either launchctl from the command line or start MySQL by clicking 'Start' using the MySQL preference pane. For additional information, see Section 2.4.3, “Installing and Using the MySQL Launch Daemon”, and Section 2.4.4, “Installing and Using the MySQL Preference Pane”. Use the MySQL Preference Pane or launchd to configure MySQL to automatically start at bootup.
When installing using the package installer, the files are installed into a directory within
/usr/local
matching the name of the installation version and platform. For example, the installer file mysql-8.0.24-osx10.15-x86_64.dmg
installs MySQL into /usr/local/mysql-8.0.24-osx10.15-x86_64/
with a symlink to /usr/local/mysql
. The following table shows the layout of this MySQL installation directory.![Mysql Preference Pane Mac Download Mysql Preference Pane Mac Download](/uploads/1/2/6/4/126469505/312899056.png)
The macOS installation process does not create nor install a sample
my.cnf
MySQL configuration file.Table 2.7 MySQL Installation Layout on macOS
Directory | Contents of Directory |
---|---|
bin | mysqld server, client and utility programs |
data | Log files, databases, where /usr/local/mysql/data/mysqld.local.err is the default error log |
docs | Helper documents, like the Release Notes and build information |
include | Include (header) files |
lib | Libraries |
man | Unix manual pages |
mysql-test | MySQL test suite ('MySQL Test' is disabled by default during the installation process when using the installer package (DMG)) |
share | Miscellaneous support files, including error messages, dictionary.txt , and rewriter SQL |
support-files | Support scripts, such as mysqld_multi.server , mysql.server , and mysql-log-rotate . |
/tmp/mysql.sock | Location of the MySQL Unix socket |
2.4.4 Installing and Using the MySQL Preference Pane
The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL installation.
Mysql Preference Pane Mac
This preference pane is installed by default, and is listed under your system's System Preferences window.
Figure 2.21 MySQL Preference Pane: Location
The MySQL preference pane is installed with the same DMG file that installs MySQL Server. Typically it is installed with MySQL Server but it can be installed by itself too.
To install the MySQL preference pane:
- Go through the process of installing the MySQL server, as described in the documentation at Section 2.4.2, “Installing MySQL on macOS Using Native Packages”.
- Click at the Installation Type step. The 'Preference Pane' option is listed there and enabled by default; make sure it is not deselected. The other options, such as MySQL Server, can be selected or deslected.Figure 2.22 MySQL Package Installer Wizard: Customize
- Complete the installation process.
The MySQL preference pane only starts and stops MySQL installation installed from the MySQL package installation that have been installed in the default location.
Once the MySQL preference pane has been installed, you can control your MySQL server instance using this preference pane.
The Instances page includes an option to start and stop MySQL, and recreates the
data/
directory. uninstalls MySQL Server and optionally the pain and launchd information. The Instances page includes an option to start or stop MySQL, and recreates the
data/
directory. uninstalls MySQL Server and optionally the MySQL preference panel and launchd information.Figure 2.23 MySQL Preference Pane: Instances
The Configuration page shows MySQL Server options including the path to the MySQL configuration file.
Figure 2.24 MySQL Preference Pane: Configuration
Mysql For Mac
The MySQL Preference Pane shows the current status of the MySQL server, showing stopped (in red) if the server is not running and running (in green) if the server has already been started. The preference pane also shows the current setting for whether the MySQL server has been set to start automatically.