When the startup item is installed, you will find it here:ĭrwxr-xr-x 4 root wheel 136 /library/startupitems/MySQLCOMĪs you can see, this is a directory. On Max OS X, to start MySQL when your Mac starts, you must install the StartupItem and the System Preferences Pane that come with the download. You can find the correct name of the PID-file in the default MySQL installation directory: MySQL uses a config file, /etc/my.cnf. We need one too for the new instance, so we copy the default one and we name it /etc/my2.cnf.Įdit the file and change, or add, the following options: We need one too, so we create /usr/local/mysql2/data/. MySQL uses a data directory to store all files and databases in, /usr/local/mysql/data/. Getting started (manual MySQL installation) Manage the multiple instances with MySQL WorkbenchĢ. Getting startedThe other chapters have subsections for each type of installation. Getting started- for a server Mac, like an Xserve or a Mac Mini Server, where you just switch MySQL on via Server Admin. for a client Mac, like an iMac at home or at work, where you install MySQL manually. If you cannot log in as root, you must use the sudo-command in front of almost every terminal command. To identify a second instance, we chose to use a 2 as the suffix for configuration files and such and we will be running it over port 3307 (the default port of MySQL is 3306).īefore you start, open Terminal and log in as root.

We did set this up on Mac OS X, but the instructions for the manual installation of MySQL should be portable, with minor changes, to other UNIX and Linux distributions (-> Instructions on how to install MySQL manually). Each instance should have its own data directory so we can separate loads across multiple mysqld daemons and set up replication for different servers onto one server. We searched for an easy method to create as many individually running MySQL instances on one computer as we want. Thanks go to Bob Vos for helping sorting this out. Install multiple MySQL instances On Mac OS X Client and Server

How to open mysql in mac