Starting with SQL

Discussion in 'Mac Programming' started by druid, Oct 21, 2006.

  1. druid macrumors newbie

    Aug 16, 2006

    I have just installed mySQL on my mac. It seems to have been installed, although when i try to start the database nothing seems to happen

    andrew-roberts-powerbook-g4-15:~ Drew$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
    Starting MySQL database server
    andrew-roberts-powerbook-g4-15:~ Drew$ 
    Im guessing ive missed something, and im guessing its obvious. I have tried the docs on the website, but none seemed to answer this problem

    Can anyone shed some light? Much appreciated
  2. MrFrankly macrumors regular

    Jan 11, 2006
    what do you expect to see?

    You started the server which just serves but doesn't offer an interface.

    If you want an interface to enter SQL queries you have to get a client that can connect to the server you just started. MySQL comes with a client called 'mysql' in which you can type SQL queries. Try typing 'mysql' on the command prompt. If that doesn't work you have to locate the binary and start it from there.
  3. druid thread starter macrumors newbie

    Aug 16, 2006

    I was expecting some form of confirmation but obviously not. I tried typing in 'mysql' at first, but got

    -bash: mysql: command not found 
    Im guessing I should
    but what does that mean?

    Many thanks
  4. robbieduncan Moderator emeritus


    Jul 24, 2002
    mysql appears to be the mysql monitor program. On my install this is in /usr/local/mysql/bin. If you want this command to be available without typing all that you need to add it to your PATH environment variable. Do a search, this has been covered more than one.

Share This Page