New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Web Design and Hosting Creating sites, scripting, and hosting discussions.

MySQL on OSX?


Post Reply New Thread Subscribe

 
Thread Tools
[Ex3]Intrigue

 
Member Since: Jul 25, 2008
Posts: 5
[Ex3]Intrigue is on a distinguished road

[Ex3]Intrigue is offline
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....
QUOTE Thanks
Thyamine

 
Thyamine's Avatar
 
Member Since: Apr 23, 2007
Location: Coatesville, PA
Posts: 377
Thyamine will become famous soon enough
Mac Specs: MBP 15", 2.33 GHz, 2Gb

Thyamine is offline
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?
QUOTE Thanks
Sherman Homan

 
Member Since: Oct 27, 2006
Posts: 897
Sherman Homan is a jewel in the roughSherman Homan is a jewel in the roughSherman Homan is a jewel in the rough

Sherman Homan is offline
This is my fave SQL on a Mac site:
http://dev.mysql.com/doc/refman/5.0/...tallation.html
Installs, instructions, test queries, etc.
QUOTE Thanks
[Ex3]Intrigue

 
Member Since: Jul 25, 2008
Posts: 5
[Ex3]Intrigue is on a distinguished road

[Ex3]Intrigue is offline
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
QUOTE Thanks
Thyamine

 
Thyamine's Avatar
 
Member Since: Apr 23, 2007
Location: Coatesville, PA
Posts: 377
Thyamine will become famous soon enough
Mac Specs: MBP 15", 2.33 GHz, 2Gb

Thyamine is offline
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.
QUOTE Thanks
[Ex3]Intrigue

 
Member Since: Jul 25, 2008
Posts: 5
[Ex3]Intrigue is on a distinguished road

[Ex3]Intrigue is offline
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
QUOTE Thanks
wheelguy

 
wheelguy's Avatar
 
Member Since: Jun 18, 2006
Location: Minneapolis
Posts: 191
wheelguy will become famous soon enough
Mac Specs: MacBook Pro

wheelguy is offline
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
QUOTE Thanks
karudzo

 
Member Since: May 27, 2006
Location: Concord, NC
Posts: 445
karudzo has a spectacular aura about
Mac Specs: Macbook Pro 17" 2.6GHz 4GB RAM

karudzo is offline
Type
sudo /usr/local/mysql/bin/mysql -u root
QUOTE Thanks
[Ex3]Intrigue

 
Member Since: Jul 25, 2008
Posts: 5
[Ex3]Intrigue is on a distinguished road

[Ex3]Intrigue is offline
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.
QUOTE Thanks
Thyamine

 
Thyamine's Avatar
 
Member Since: Apr 23, 2007
Location: Coatesville, PA
Posts: 377
Thyamine will become famous soon enough
Mac Specs: MBP 15", 2.33 GHz, 2Gb

Thyamine is offline
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.
QUOTE Thanks
[Ex3]Intrigue

 
Member Since: Jul 25, 2008
Posts: 5
[Ex3]Intrigue is on a distinguished road

[Ex3]Intrigue is offline
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.
QUOTE Thanks
jivhg

 
Member Since: Aug 01, 2008
Posts: 6
jivhg is on a distinguished road

jivhg is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Problems with browser compatibility | I want to use iWeb to make a website, What hosting service should i use? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Compiling MySQL for Leopard Neko_D OS X - Operating System 0 05-26-2008 06:56 PM
Fresh install of MySQL denies access to root IceLatte Web Design and Hosting 0 06-24-2007 05:04 PM
MS contingency to buy OSX mass licence Smartz Apple Rumors and Reports 16 03-28-2006 01:40 PM
Broken Disk Drive but Want to Upgrade to OSX...Impossible? mariamarchita OS X - Operating System 3 02-27-2005 01:52 PM
printing PostScript with OSX davidp158 OS X - Operating System 9 02-09-2005 08:56 PM

All times are GMT -4. The time now is 02:56 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?