Will Snow Leopard work with MySQL, Tomcat etc?

[raymondu999]

Hey all. I'm a student in Uni doing INformation Systems. I'm wondering if things like Apache, Tomcat, and MySQL will work immediately flawlessly on Snow Leopard. I need these for project work so if they might not work on SL I might have to delay my upgrade plans

 

[iShater]

I would be surprised if they don't work.

 

[Eraserhead]

I'd be interested in knowing this as well.

 

[xper]

MySQL works with MAMP so it should work standalone to!

 

[bootedbear]

I've been running Tomcat since 10.0 and PostgreSQL since 10.4, and an upgrade has never cause any types of problems. I can't see SL being any different.

 

[brasscat]

Last night I installed MySQL 64-bit onto SL and it works without a problem. If you use the service run/stopper in the preference pane, that works as well, but only in 32 bit mode.

 

[dbell]

Both work fine for me.

 

[tercerojista]

I was running MySQL on Leopard. Last night I installed Snow Leopard. I found that I could no longer get MySQL to run.

I use the 'mysql.server start' command in terminal. The mysql.server executable is still on my computer. It's in exactly the same place:

usr/local/mysql-5.0.51b-osx10.5-/support-files

If I go there in terminal, and try the mysql.server start command, I get the message:

mysql.server: command not found

(yes, I'm running as SU)

Not sure what's gone wrong here...

I'm not greatly surprised that something went wrong here. When I Google for information about MySQL on OS X, I find SO MANY different ways of installing and starting the software, that it's all really rather confusing...

 

[raymondu999]

so can I make the assumption that installing MySQL after an SL install works, but not having it run from a previous installation running on Leopard?

How about Apache and Tomcat?

 

[Not Available]

so can I make the assumption that installing MySQL after an SL install works, but not having it run from a previous installation running on Leopard?

How about Apache and Tomcat?

I'm not certain about Tomcat, but Apache should work as well, the version included with MAMP works.

 

[erichepler]

After Upgrade, MySQL stopped, now I fixed

Was running php5 + MySQL.

When i went to http://localhost i got "It Works!" instead of my application that i've been developing locally. I think thats an apache2 index error, i may just need to add index.php back to the index directives.

When I loaded http://localhost/index.php explicity... php code executed but I could not connect to MySQL. I went to system preferences to the MySQL Admin icon, and it first said it needs to restart System Preferences in order to load MySQL Admin pane... ok... Did that, and there was an error saying could not find "/usr/local/mysql/bin/mysqld_safe". I went to the Terminal and saw that I didnt have a /usr/local/mysql but instead a /usr/local/mysql-5.1.30-osx10.5-x86 so I created a symbolic link "ln -s /usr/local/mysql-5.1.30-osx10.5-x86 /usr/local/mysql" and restarted mac and it works now. Everything seems kosher in my system preferences/mysql pane now too.

Hope this helps some of you, perhaps I could have reinstalled MySQL to fix too.

 

[budhadha]

I was running MySQL on Leopard. Last night I installed Snow Leopard. I found that I could no longer get MySQL to run.

I use the 'mysql.server start' command in terminal. The mysql.server executable is still on my computer. It's in exactly the same place:

usr/local/mysql-5.0.51b-osx10.5-/support-files

If I go there in terminal, and try the mysql.server start command, I get the message:

mysql.server: command not found

(yes, I'm running as SU)

Not sure what's gone wrong here...

I'm not greatly surprised that something went wrong here. When I Google for information about MySQL on OS X, I find SO MANY different ways of installing and starting the software, that it's all really rather confusing...

I had the same problem here, you just have to go into /usr/local and make a soft link to your mysql directory version and name this link mysql. It solved the problem for me.

 

[elppa]

I had the same problem here, you just have to go into /usr/local and make a soft link to your mysql directory version and name this link mysql. It solved the problem for me.

Ditto.

[1] Make a alias (soft link) called “mysql” in /usr/local/ that points to your mysql installation (it will likely be in /usr/local/ and called something like “mysql-5.0.77-osx10.5-x86”). In Terminal:

cd /usr/local/

ln -s /usr/local/mysql-5.0.77-osx10.5-x86/ mysql

[2] Use the preference panel to start mysql.

-or-
If you have a Time Machine backup prior to upgrading:
[1] Navigate to /usr/local/
[2] Choose “Enter Time Machine” from the Time Machine icon in the menu bar.
[3] Restore the mysql alias from the last backup you took prior to upgrading to Snow Leopard.
[4] Use the preference panel to start mysql.

It appears that when Snow Leopard upgrades from Leopard it removes this alias.

 

[tercerojista]

I had the same problem here, you just have to go into /usr/local and make a soft link to your mysql directory version and name this link mysql. It solved the problem for me.

Thank you very much indeed! I was hoping for a simple solution

 

[superfunkomatic]

i had an existing mysql build running. will this work and allow the old data to work?
also do i need to install the 32 or 64 bit version of mysql for x86?
i've restored to 10.5.x to keep my webserver working, but this would be great if it's a simple process of:

1) install 64 bit mysql
2) install startup item for mysql
3) create soft link to new mysql directory
4) and have all data work with existing web-based apps.

any help would be appreciated.

Ditto.

[1] Make a alias (soft link) called “mysql” in /usr/local/ that points to your mysql installation (it will likely be in /usr/local/ and called something like “mysql-5.0.77-osx10.5-x86”). In Terminal:

cd /usr/local/

ln -s /usr/local/mysql-5.0.77-osx10.5-x86/ mysql

[2] Use the preference panel to start mysql.

-or-
If you have a Time Machine backup prior to upgrading:
[1] Navigate to /usr/local/
[2] Choose “Enter Time Machine” from the Time Machine icon in the menu bar.
[3] Restore the mysql alias from the last backup you took prior to upgrading to Snow Leopard.
[4] Use the preference panel to start mysql.

It appears that when Snow Leopard upgrades from Leopard it removes this alias.

 

[elppa]

i had an existing mysql build running. will this work and allow the old data to work?

Yes, this is exactly the same situation I was in and after placing the link and restarting all my databases and tables were in place.

also do i need to install the 32 or 64 bit version of mysql for x86

You can use either, at present I am using 32 bit version of 5.0.77.

i've restored to 10.5.x to keep my webserver working, but this would be great if it's a simple process of:

1) install 64 bit mysql
2) install startup item for mysql
3) create soft link to new mysql directory
4) and have all data work with existing web-based apps.

I only needed to follow steps 3 and 4 after doing upgrade install.

 

[superfunkomatic]

I didn't get a message to do an 'upgrade install.' i was running 5.1.30 32 bit version. would that make any difference?

Yes, this is exactly the same situation I was in and after placing the link and restarting all my databases and tables were in place.


You can use either, at present I am using 32 bit version of 5.0.77.



I only needed to follow steps 3 and 4 after doing upgrade install.

 

[elppa]

I didn't get a message to do an 'upgrade install.' i was running 5.1.30 32 bit version. would that make any difference?

I think we may have our wires crossed… are you talking about upgrading mysql or Snow Leopard?

Because I was talking about upgrading Snow Leopard. What I was saying is providing you add back the “mysql” alias in /usr/local/, everything should work after upgrading from Leo > Snow Leo.

 

[superfunkomatic]

i updated to snow leopard and installed 5.1.37 - mysql didn't work. even with a fresh install mysql didn't work. that's why i thought that just adding a soft link seemed far to easy.
i'll have to give it a try now that i've reverted/restored back to 10.5.8 and 5.1.30.

I think we may have our wires crossed… are you talking about upgrading mysql or Snow Leopard?

Because I was talking about upgrading Snow Leopard. What I was saying is providing you add back the “mysql” alias in /usr/local/, everything should work after upgrading from Leo > Snow Leo.

 

[elppa]

i updated to snow leopard and installed 5.1.37 - mysql didn't work. even with a fresh install mysql didn't work. that's why i thought that just adding a soft link seemed far to easy.

This resolved the issue for me though - so it does work in some cases.

When you say “didn't work”, what part didn't work – the preference panel?

 

[dccdk]

Ditto.

[1] Make a alias (soft link) called “mysql” in /usr/local/ that points to your mysql installation (it will likely be in /usr/local/ and called something like “mysql-5.0.77-osx10.5-x86”). In Terminal:

cd /usr/local/

ln -s /usr/local/mysql-5.0.77-osx10.5-x86/ mysql

[2] Use the preference panel to start mysql.

I attempted to create this soft link but received a permission denied message.

Is there a way that I can work around this?

 

[GroovyLinuxGuy]

I attempted to create this soft link but received a permission denied message.

Is there a way that I can work around this?

Use sudo before the command, then enter your password when prompted.

 

[DanRomanchik]

Thanks!

Just wanted to thank all those who responded.

I upgraded to Snow Leopard a couple of days ago, but only this morning needed to access some of the databases on my local machine. I thought I was hosed when I couldn't connect to the server. Adding that link did the trick, though!

Dan

 

[trintha]

Tomcat confirmed working

I can confirm that Tomcat works (version 6) using the binaries from the official site and this guide: http://blog.gumho.org/2009/10/tomcat-6-on-snow-leopard.html

 

[Kaenath]

10.4->10.6 upgrade

I've upgraded my machine from 10.4 to 10.6.

I see mysqld running in activity monitor, but when i try any mysql commands in terminal, they all fall.

ProductionG5:local kaenath$ mysql
-bash: mysql: command not found

when checking my mysql folder, i'm seeing this version:

mysql-5.0.45-osx10.4-i686

Should I be upgrading this to a newer version? why didn't OSX upgrade it when I upgraded to SL?

If upgrading, where should I get the newest version from (and instructions would be helpful). Do I need to uninstall my current version?

Any current sql data is not needed.