Results 1 to 12 of 12

Thread: MySQL on OSX?

  1. #1


    Member Since
    Jul 25, 2008
    Posts
    5
    Question MySQL on OSX?
    Hey all, I'm new here (so be nice ) and am a fairly new mac user (I use them all the time for graphical work). Anyway, my dad has put me up to building him a MySQl server, and it seems to be possible from a mac, however, I am pulling my hair out over the thing. So far I've managed to actually install the binaries ( I hope), and I've been trying to access things through the native terminal. However, this is really where I'm running into trouble, the mysql isn't executing as anything, and i just get yelled at by the comp saying "command is not found", when every other printed source blathers away (and posts examples of it) being used as a command from the terminal. I'm sorry if I'm vague about this, I'm an artist, not a scripter..., but any help would be wicked appreciated.


    Btw, I wasn't sure if this should go under OS's or here, but this place I think is more appropriate....

  2. #2

    Thyamine's Avatar
    Member Since
    Apr 23, 2007
    Location
    Coatesville, PA
    Posts
    377
    Specs:
    MBP 15", 2.33 GHz, 2Gb
    Are you sure that the server is started now that it's installed? Was there a log generated during the install that you can verify that the install went fine?

  3. #3


    Member Since
    Oct 27, 2006
    Posts
    897
    This is my fave SQL on a Mac site:
    http://dev.mysql.com/doc/refman/5.0/...tallation.html
    Installs, instructions, test queries, etc.

  4. #4


    Member Since
    Jul 25, 2008
    Posts
    5
    hey, thanks for the fast replies, you guys are savin' me. I got as far as trying to set the password for the server, but now I can't login as root. In the terminal I punch in:

    shell> mysql -u root

    and all I get is:

    bash: mysql: permission denied


    I was under the impression these accounts on a unix system started up as non passworded. If they are how do put the password in, or general how do i get around this/now what did i do wrong?


    thanks again guys

  5. #5

    Thyamine's Avatar
    Member Since
    Apr 23, 2007
    Location
    Coatesville, PA
    Posts
    377
    Specs:
    MBP 15", 2.33 GHz, 2Gb
    You could always try a 'sudo mysql -u root'. I haven't tried using MySQL from the command line, so I'm not sure otherwise.

  6. #6


    Member Since
    Jul 25, 2008
    Posts
    5
    thanks for the info dude, but when i do that I just get

    "sudo: mysql: command not found"


    Sometimes I think my comp likes making me squirm

    Btw, honestly, thanks for the fast replies and the help, you guys are wicked

  7. #7

    wheelguy's Avatar
    Member Since
    Jun 18, 2006
    Location
    Minneapolis
    Posts
    191
    Specs:
    MacBook Pro
    I run Apache and Mysql on my Macbook Pro via Xampp. It works flawlessly and was very easy to install. You can find it here http://www.apachefriends.org/en/xampp-macosx.html
    If you aren't fired with enthusiasm, you will be fired with enthusiasm. -Vince Lombardi

  8. #8


    Member Since
    May 27, 2006
    Location
    Concord, NC
    Posts
    445
    Specs:
    Macbook Pro 17" 2.6GHz 4GB RAM
    Type
    sudo /usr/local/mysql/bin/mysql -u root

  9. #9


    Member Since
    Jul 25, 2008
    Posts
    5
    hey karudzo, your line seemed to want to work as it asked for my pass (hoorah!). However this one is up for anyone to determine, but I'm now getting

    "ERROR 2002 (HY000): Can't connect to local MysQL server trhough socket ' /tmp/Mysql.sock' (2)

    I'm going to do a good bit of digging on this one as it seems to be almost a router issue of some sort.

  10. #10

    Thyamine's Avatar
    Member Since
    Apr 23, 2007
    Location
    Coatesville, PA
    Posts
    377
    Specs:
    MBP 15", 2.33 GHz, 2Gb
    It shouldn't be a router issue since you are running and trying to connect to it on the same system. However, it could be a networking/configuration error in that MySQL isn't sure where to be listening, or that the client is trying to connect in the wrong way.

  11. #11


    Member Since
    Jul 25, 2008
    Posts
    5
    yeah, actually that does make more sense. I'm gonna give Xampp a shot tonight while I'm at this I think, can't hurt.

  12. #12


    Member Since
    Aug 01, 2008
    Posts
    6
    I used my Leopard CLient as a Full Fledged Web Server once, PHP, Apache, MySQL, DNS, e-mail, all working, but i took it off because i have an iMac anda webserver will kill it.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mySQL
    By burnedfaceless in forum Web Design and Hosting
    Replies: 1
    Last Post: 02-03-2014, 09:36 AM
  2. mysql and ssl
    By danielb in forum OS X - Apps and Games
    Replies: 1
    Last Post: 07-06-2008, 02:34 PM
  3. mac osx server. (php/mysql)
    By design2 in forum Web Design and Hosting
    Replies: 5
    Last Post: 07-30-2005, 04:02 AM
  4. MySQL question
    By Dark Phoenix in forum Web Design and Hosting
    Replies: 4
    Last Post: 04-11-2005, 07:54 PM
  5. MySQL
    By ftjogoh in forum Web Design and Hosting
    Replies: 3
    Last Post: 11-21-2004, 12:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •