Getting MySQL Running on OSX 10.7 Lion

Question

I'm currently trying to get MySQL to work with OSX 10.7 Lion. I tried the brew method:

brew install mysql -> cmake -> no problems -> make -> no problems -> make install -> no problems -> done unset TMPDIR mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp Installing MySQL system tables... /usr/local/bin/mysql_install_db: line 428: 15397 Done { echo "use mysql;"; cat $create_system_tables $fill_system_tables; } 15398 Done(141) | eval "$filter_cmd_line" 15401 Segmentation fault: 11 | $mysqld_install_cmd_line > /dev/null Installation of system tables failed! Examine the logs in /usr/local/var/mysql for more information. 

Has anyone run mysql on Lion?

Answer 1

You can download the MySQL installer as a DMG file, complete with the installer, the system settings panel and running the script directly from MySQL. Go to the MySQL community server download page , select Mac OS X as the platform, and select the DMG file.

You can skip the registration form (there is a small link under the registration form), and you should be on your way.

After downloading the file, double-click DMG, run the installer and complete the installation. After that, install the start script using its installer and, finally, the settings panel by double-clicking on it. I highly recommend installing it for all users on the computer.

You will find this method much easier than compiling from source.

You should check out Sequel Pro if you need a great OS X tool for managing MySQL databases.

Answer 2

Cancel replacement for mysql - mariadb . You can install with brew install mariadb '. It is based on Leo.

Existing mysql drivers and clients just work. I use it with python-mysql and django.

It is even called mysql, so you won’t even know the difference.

Answer 3

Ha! Got it!

First ... download mysql-5.6.2 here: http://dev.mysql.com/downloads/mirror.php?id=402349#mirrors ... as soon as you finish, unzip the file and do the following:

 mv path/to/mysql-5.6.2-m5-osx10.6-x86_64 /usr/local/mysql echo "PATH=\$PATH:/usr/local/mysql/bin" >> ~/.profile # open a new tab cd /usr/local/mysql #this is essential! ./scripts/mysql_install_db mysqld_safe & mysql -uroot 

works for me :)

Answer 4

You also need to set up the environment of your path, as well as correctly configure the root password when you are on it. I created the complete step by step here: How to install MySQL on Lion (Mac OS X)

Answer 5

All,

I am having problems connecting to my database via Tomcat, but using the MySql tool. Tomcat accessed it through the actual IP address of my machine (10.0.xx), and not through localhost or 127.0.0.1. It turns out that when I switched from SL to Lion, remote connections were disconnected. As soon as I turned them on, it worked fine.

Hope this helps someone.

Answer 6

I already installed MySQL, but after upgrading to Lion, it no longer started.

I tried to install the latest official version, and it still did not start.

Finally, it fixed this:

 $ sudo mkdir /var/log/mysql $ sudo chown mysql:mysql /var/log/mysql