There is a small issue with installing MySQL on Leopard. The preference pane to start/stop Mysql does not work. Don’t know why but it just doesn’t. It will start manually but you need to make a slight adjustment to one file called ‘mysql.server’ in the directory ‘/usr/local/mysql/support-files/’. On line 62 change:
into
The following has happened in Leopard. All the users that are used for running applications have a changed username. All the daemon users start with an underscore in Leopard. This means that the user ‘mysql’ which we remember in Tiger is currenty known as ‘_mysql’. You will see this user as the owner of ‘/usr/local/mysql/data’. So somehow everything gets installed with the correct user.
The error of the Preference pane has been logged as a bug on the MySQL bug site.
If anyone can explain why the usernames have changed I would like to know!
By the way the only difference in installing MySQL on Leopard is the configure statement to compile MySQL, the rest is still the same. The new ./configure statement for PowerPC and Intel based Macs is:
–localstatedir=/usr/local/mysql/data \
–libexecdir=/usr/local/mysql/bin \
–libdir=/usr/local/mysql/lib \
–with-server-suffix=-standard \
–enable-thread-safe-client \
–enable-local-infile \
–enable-shared \
–with-zlib-dir=bundled \
–with-big-tables \
–with-readline \
–with-archive-storage-engine \
–with-innodb \
–without-docs \
–without-bench
As you see the CFLAGS have gone, the new XCode tools do their auto detection a lot better I guess.
Comments
5:53 pm
Ok, this is the ‘th time ive tried to do this, but every time the self install seems to miss out the sock file, can’t find it anywhere, either in my computer nor any solution on the web!
6:33 pm
Try the command mysql_config and it will tell you where it is.
11:27 pm
In case you would like to use mysql with the pre-installed Apache 2.2 and PHP 5.2.4 of MacOS X 10.5 (Leopard):
1. Follow the install instructions of dev.mysql.com (2.8. Installing MySQL from tar.gz Packages on Other Unix-Like Systems). But note:
- Use sudo in front of each command line.
- Use _mysql as user for the mysql-commands (–user=_mysql)
2. Create a directory /var/mysql (e.g. use sudo for mkdir)
3. Change into this directory (cd /var/mysql)
4. Create the following link: sudo ln -s /tmp/mysql.sock mysql.sock
First I tried to adapt the expected mysql file structure in the php configuration files to the real one (in config.inc.php) but I did not succeed. I assume that this is the preferable solution.
7:21 pm
This new prefpane from MySQL finally fixes the issue. Took them long enough.
ftp://ftp.mysql.com/pub/mysql/download/gui-tools/MySQL.prefPane-leopardfix.zip
11:59 pm
Martijn, it only solves one of the issues. But it does help, I’ve recently blogged about it…
3:39 pm
I have installed the fixed prefpane for Leopard and it still isn’t working. Does anyone else have an idea of what to try?!
Cheers
6:31 pm
Paul had not upgraded MySQL to the latest version. He’s got it working now…
10:37 pm
I’ve spent hours trying to get mySQL to work with still no success… the new prefpane still freezes my system preferences and I have to force quit..
I’ve tried to manually start mySQL with terminal and it gives me this message:
Morgan-Plants-Computer:~ morganplant$ sudo /usr/local/mysql/support-files/mysql.server start
Password:
/usr/local/mysql/support-files/mysql.server.real: fork: Resource temporarily unavailable
Morgan-Plants-Computer:~ morganplant$
No idea what’s goin on here.. Should I uninstall everything and start over again? im kinda a newb to this so any help would be greatly appreciated.. thanks
oh yea I have a 1.33 Ghz PowerPC G4 with Leopard 10.5.5..