wood burning stoves 2.0*
The moose likes Mac OS and the fly likes Installing MySQL Community Server 10.7 on MacBook Pro Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Engineering » Mac OS
Bookmark "Installing MySQL Community Server 10.7 on MacBook Pro" Watch "Installing MySQL Community Server 10.7 on MacBook Pro" New topic
Author

Installing MySQL Community Server 10.7 on MacBook Pro

Siddharth Bhargava
Ranch Hand

Joined: Feb 23, 2007
Posts: 266
Hi All,

I am trying to install MySQL Community Server 10.7 on my MacBook Pro OS X 10.8.3. The installation is successful but I am not able to find the folder as to where its installed. I am not able to locate the folder where it installed? I was able to successfully install MySQL Workbench and also am able to successfully open it.

Please do let me know as to how to open the MySQL Community Server in my MacBook Pro.


Thanks and Regards,
Sid.
Pat Farrell
Rancher

Joined: Aug 11, 2007
Posts: 4659
    
    5

I never could get the standard MySql install to work, or work well.

I resolved it by installing the MAMP stack. This is a Mac OS-X specific version of the world famous LAMP stack.
LAMP stands for Linux, Apache. MySql and Php (or perl)
thus MAMP replaces Linux with Mac OS-X

I never looked back once I found MAMP
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11464
    
  94

It is a long, long time since I installed MySql on a Mac using the standard installers, so this information may be wrong.

Try looking in "System Preferences" - is there a "MySQL" applet in the "Other" section (very bottom). If so, you may be able to start / stop your MySQL server using that, and choose whether to have it auto-start when your Mac starts.

From memory, both the MySQL Workbench and the Admin tool were both installed in the /Applications folder.


The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11464
    
  94

Pat Farrell wrote:I resolved it by installing the MAMP stack.


I never really understood what the purpose of that stack was. Macs come with Macintosh (of course), Apache, and PHP already installed. In my mind this equates to getting a "stack" that only adds one item. Unless the "stack" does some configuration to make them all aware of each other.

Am I missing something?
Pat Farrell
Rancher

Joined: Aug 11, 2007
Posts: 4659
    
    5

Andrew Monkhouse wrote:
Pat Farrell wrote:I resolved it by installing the MAMP stack.
I never really understood what the purpose of that stack was. Macs come with Macintosh (of course), Apache, and PHP already installed. Am I missing something?


I don't fully understand it either. All I know is that when I installed MAMP, everything worked as expected.

I think it installs a new, more straight-from-Apache HTTPD. Don't know which PHP it was.

MAMP has a GUI controller that I never use.
Siddharth Bhargava
Ranch Hand

Joined: Feb 23, 2007
Posts: 266
Pat Farrell wrote:I never could get the standard MySql install to work, or work well.

I resolved it by installing the MAMP stack. This is a Mac OS-X specific version of the world famous LAMP stack.
LAMP stands for Linux, Apache. MySql and Php (or perl)
thus MAMP replaces Linux with Mac OS-X

I never looked back once I found MAMP


Are we trying to say that we can't successfully install MySQL Community Server 10.7 on the MacBook Pro Mac OS X 10.8.3 ? As mentioned in my post I have successfully installed and ran MySQL Workbench latest version which is "MySQL Workbench CE for Mac OS X version 5.2.47 revision 10398" on my MacBook Pro Mac OS X 10.8.3.

If I am not able to install the MySQL Community Server then the Workbench is of no use. Its weird first it says that it is successfully installed and then there is no icon or directory where I can see it installed. Is is some kind of a bug in MySQL or Mac OS X 10.8.3 ? I am stuck. Please Help !!!
Siddharth Bhargava
Ranch Hand

Joined: Feb 23, 2007
Posts: 266
Andrew Monkhouse wrote:It is a long, long time since I installed MySql on a Mac using the standard installers, so this information may be wrong.

Try looking in "System Preferences" - is there a "MySQL" applet in the "Other" section (very bottom). If so, you may be able to start / stop your MySQL server using that, and choose whether to have it auto-start when your Mac starts.

From memory, both the MySQL Workbench and the Admin tool were both installed in the /Applications folder.


I saw in the "System Preferences" there is no "MySQL" applet in the "Other" section. I do get the My SQL Workbench icon in the Application folder but there is no icon for MySQL Community Server.
Pat Farrell
Rancher

Joined: Aug 11, 2007
Posts: 4659
    
    5

Siddharth Bhargava wrote:Are we trying to say that we can't successfully install MySQL Community Server 10.7 on the MacBook Pro Mac OS X 10.8.3 ?


Not so broadly. I wrote that I could not install MySql community server on my MBP. I gave up after a few days of frustration and installed MAMP and all was joy and happiness
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11464
    
  94

I just went through the installation again just to confirm it worked for me. This is a long, detailed post, but hopefully if you follow along you will be able to come back and say where something is different on your computer.

When I downloaded the DMG, I see 3 install options, and a ReadMe.txt file:



I ran the mysql-5.6.11-osx10.7-x86_64.pkg file, and a few minutes later it told me that it had successfully installed. (I agree - this is less than helpful at this point). I confirmed that it was installed:



Line 3 shows where it is really installed to, while line 2 shows the symbolic link that was set up for me by the install process. All looks good.

I then installed the MySQL.prefPane (double clicked the icon in the install DMG - it told me that it needed to be installed to the preferences panel). Once that was done I had a new icon in my preferences panel:



Clicking that button gave me a new set of options (although it started out with MySQL Server not running - I clicked the "Start MySQL Server" button to get it started).



I confirmed that the server was now running:



Finally, I logged into MySQL to ensure it was all working correctly:



Siddharth Bhargava
Ranch Hand

Joined: Feb 23, 2007
Posts: 266
Andrew Monkhouse wrote:I just went through the installation again just to confirm it worked for me. This is a long, detailed post, but hopefully if you follow along you will be able to come back and say where something is different on your computer.

When I downloaded the DMG, I see 3 install options, and a ReadMe.txt file:



I ran the mysql-5.6.11-osx10.7-x86_64.pkg file, and a few minutes later it told me that it had successfully installed. (I agree - this is less than helpful at this point). I confirmed that it was installed:



Line 3 shows where it is really installed to, while line 2 shows the symbolic link that was set up for me by the install process. All looks good.

I then installed the MySQL.prefPane (double clicked the icon in the install DMG - it told me that it needed to be installed to the preferences panel). Once that was done I had a new icon in my preferences panel:



Clicking that button gave me a new set of options (although it started out with MySQL Server not running - I clicked the "Start MySQL Server" button to get it started).



I confirmed that the server was now running:



Finally, I logged into MySQL to ensure it was all working correctly:





Hi Andrew,

Thanks a lot Andrew. Excellent explanation.

I followed the screenshots and steps provided by you and it proved to be really helpful.

Basically the step which i was missing was I didn't run/install MySQL.prefPane so I didn't have the MySQL icon in the preferences panel.

I also got the other screenshot in which I checked the checkbox Automatically start MySQL Server on Startup.

Also I did have all the files in the folder /usr/local/mysql/bin

Thus I was able to start my MySQL Community Server and then I connected MySQL Workbench with it.

I am happy.

Thanks a TON again for solving this for me.

Thanks and Regards,
Siddharth
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Installing MySQL Community Server 10.7 on MacBook Pro