Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system.

First, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg.

Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows

  1. mysql-5.5.28-osx10.6-x86_64.pkg -> I double-clicked it to run, after clicked buttons a few times it's said to be successfully installed. However, I could not see anything in Applications.

  2. MySqlStartupItem.pkg -> I double-clicked to run, also successfully done. However, I still could not see anything in Applications.

  3. MySQL.prefPane -> I double-clicked it to run. Now I see a window jumped out, with a button Start/Stop MySQL Server, I clicked it, now it says "The MySQL Server Instance is running".

I'm a bit lost here:

Q1. Why until now there's nothing in the Applications? I can't see any item or folder like mysql there. Is it that every time I want to run mysql, I have to mount the installation package?

Q2. What did MySQLStartupItem.pkg install?

Q3. Are there any client side tools inside the installation package? I mean, for example, Microsoft SQL Server for Windows, there are Microsoft SQL Server; and there are Microsoft SQL Server Management Studio, which serves as a client tool to browse databases and doing queries; also, if I download "Microsoft SQL Server Express with Tools" package, it will install both. Does mysql-5.5.28-osx10.6-x86_64.dmg contain only the server, or also a client tool inside?

share|improve this question
    
"Are there any client side tools inside the installation package". Yes: the mysql commandline tool. –  a_horse_with_no_name Nov 25 '12 at 12:19
add comment

3 Answers 3

up vote 1 down vote accepted

MySQL installs the database engine. Which you run and start from the terminal/bash/shell.

You will need to download the MySQL workbench for a GUI.

phpmMyAdmin is another choice which runs in the browser.

Sounds like you have MySQL installed. You just need to setup a GUI now.

Q1. why until now there's nothing in the applications? I can't see any item or folder like mysql there. is it that every time i want to run mysql, i have to mount the installation package?

A1: The dB engine is installed you have to start and stop it using terminal window.

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

Q2. what does MySQLStartupItem.pkg installed?

A2: The Startup Item installation adds a variable MYSQLCOM=-YES- to the system configuration file /etc/hostconfig.

Q3. Is there any client side tools inside the installation package? I mean, for example, Microsoft SQL Server for Windows, there are Microsoft SQL Server; and there are Microsoft SQL Server Management Studio, which serves as a client tool to browse databases and doing queries; also, if i download "Microsoft SQL Server Express with Tools" package, it will install both. does "mysql-5.5.28-osx10.6-x86_64.dmg" contains only the server, or also a client tool inside?

A3: Lots. phpMyAdmin for browser. And MySQLWorkBench equal to SQL Server Management Studio (Browse dB's and other objects)

share|improve this answer
    
thanks Craig, it works! :) let me try get familiar to MySQLWorkBench :) –  athos Nov 12 '12 at 15:47
    
Shouldn't the mysql commandline ("client side tool") be part of a base installation? –  a_horse_with_no_name Nov 25 '12 at 12:18
add comment

You can install it via Homebrew

brew install mysql

This will install the mysql deamon and the cli tool.

share|improve this answer
    
thanks, i'm sure it works, but now let me stay on a conventional way... –  athos Nov 12 '12 at 15:47
add comment

This package actually also installs the command-line interface (CLI) for MySQL, but does not put it in your $PATH.
The solution is to first run the two commands below in a terminal:

$ echo "export PATH=$PATH:/usr/local/mysql/bin" >> ~/.profile
$ source ~/.profile

Then you can use the CLI as explained here.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.