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....

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?

This is my fave SQL on a Mac site:
http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html
Installs, instructions, test queries, etc.

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

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.

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

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

Type
sudo /usr/local/mysql/bin/mysql -u root

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.

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.

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.

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.