5

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?

Improve this question
1
  • "Are there any client side tools inside the installation package". Yes: the mysql commandline tool.
    – user1822
    Nov 25, 2012 at 12:19

3 Answers 3

Reset to default
1

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)

Improve this answer
2
  • thanks Craig, it works! :) let me try get familiar to MySQLWorkBench :)
    – athos
    Nov 12, 2012 at 15:47
  • Shouldn't the mysql commandline ("client side tool") be part of a base installation?
    – user1822
    Nov 25, 2012 at 12:18
4

You can install it via Homebrew

brew install mysql

This will install the mysql deamon and the cli tool.

Improve this answer
0
1

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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