MySQL for Lion Server

macintosh doctor · May 11th, 2012, 12:07 PM

Has any one installed it successfully?
there are a million links on line with each have slightly different instructions
wondering if any one has done it and which info or install instructions they used?
thank you

Dr_AL · May 11th, 2012, 12:09 PM

I don't recall having much of an issue getting MySQL up and running with lion. Will try to sit down and remember what I did this afternoon if nobody chimes in first.

Sent from my iPhone

macintosh doctor · May 11th, 2012, 12:36 PM

	Quote:			Originally Posted by dr_al
	i don't recall having much of an issue getting mysql up and running with lion. Will try to sit down and remember what i did this afternoon if nobody chimes in first. Sent from my iphone

sweet thanks

Dr_AL · May 11th, 2012, 03:31 PM

Have you attempted to install and set up MySQL?

macintosh doctor · May 11th, 2012, 06:22 PM

here is what I have done and reformatted the server and decided to start over - after I found simpler instructions.

i tried these instructions but, he has misleading info..which makes no sense..
Installing MYSQL on 10.7 Server | Musings of an Apple Systems Administrator
I got half way.. step 3 says mk mysql and give it permissions
then he says to do again.. which I am lost at that point..
then if you do continue - he makes you redo what you did during the sql install..

then this link: Setting up PHP & MySQL on OS X 10.7 Lion – Rob Allen's DevNotes
seems way to simple..
but conflicts with the other guy..
what is the difference with .bash_profile vs .profile
once that is clarified with me, I will understand which to use..

then i will install myphpadmin and wordpress..
thanks

Dr_AL · May 11th, 2012, 06:43 PM

These steps seem familiar to what I did.
http://edvindev.wordpress.com/2011/1...-php-and-mysq/

I'm using MySQL Workbench to manage databases.

Sent from my iPhone

CoderMummy · May 13th, 2012, 08:37 PM

MAMP worked fine for me

macintosh doctor · May 14th, 2012, 08:48 AM

Lion Server - has a different requirement compared to lion client install.

CoderMummy · May 14th, 2012, 09:25 AM

Macintosh Doctor,

What are you having trouble with specifically? Just the installation process or are you having configuration issues?

I am running Lion Server on a Mac Mini mid-2011 2.3 i5 (low end model). I purchased/upgrade Lion client to server. I am only using it as a Development/Testing/File server with external storage attached, so I did not need the i7 "Server" Model with additional hard drive space.

My preferred tool has always been the Lamp/Wamp/Mamp installations of PHP/MySQL. It is a relatively easy process with a step-by-step wizard that takes care of most common configurations for you. Sure you can go in and modify the config files further but generally there is no need.

That said, you're certainly not the first person to run into configuration issues with Lion Server. I strongly recommend giving MAMP a try though... the support forums for it have a helpful community who have run into Lion Config issues as well. Once you get it running... for the most part you're Golden (until Apple updates something and you have to address it... LOL).

Here's a couple links. Not sure what you're doing with your server, but unless you are setting up multiple virtual servers you shouldn't need the Pro version.:

Mamp (Download Site): MAMP: Mac, Apache, MySQL, PHP
Forum (Use and Troubleshooting): MAMP Forum • Index page

Good Luck!

voyager99 · Jul 6th, 2012, 06:50 PM

Yeah, ever since Oracle acquired them, installing and using MySQL has been
a nightmare experience (at least for me anyway)!