Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > OS X > Mac OS X Server, Xserve, and Networking

Reply
 
Thread Tools Search this Thread Display Modes
Old May 14, 2009, 07:00 PM   #1
itsbarry
macrumors newbie
 
Join Date: May 2009
MYSQL on Mac: How to install and use?

Hello everyone,

I need your help!!! I'm trying to install MySQL on my iMac to learn SQL. I downloaded it and installed it, but I'm having so much difficulty trying to use the darn thing through the Terminal with "guides" that I've been reading online, but to no avail.

I tried MAMP, but I don't know if I'm doing something incorrect. I don't see where I would type the SQL commands.

Can anyone assist me? I've been wanting to learn this for months and I don't want to give up when I didn't even get started. If you can put it in "n00b-specific" language for me, that would be great.

Thanks again for your time and consideration.

itsbarry is offline   0 Reply With Quote
Old May 14, 2009, 11:07 PM   #2
twoodcc
macrumors P6
 
twoodcc's Avatar
 
Join Date: Feb 2005
Location: Right side of wrong
Send a message via AIM to twoodcc Send a message via MSN to twoodcc
well, you can type in sql commands in terminal.

first you have to type: mysql -u username -p

put your username in for 'username'

and it will then ask for your password. and then you can type in your sql commands.

but before you can do this, you have to set your root password. i can't remember how to do it off the top of my head. just google for it, and if you can't find it, then i'll help you look
__________________
tville
Smarter than the average bear
twoodcc is offline   0 Reply With Quote
Old May 15, 2009, 12:32 AM   #3
itsbarry
Thread Starter
macrumors newbie
 
Join Date: May 2009
Thanks for your reply.

When I try that input in the terminal, it says: command not found.

Hmmm, I'll play around with it a bit more.
itsbarry is offline   0 Reply With Quote
Old May 15, 2009, 06:48 AM   #4
twoodcc
macrumors P6
 
twoodcc's Avatar
 
Join Date: Feb 2005
Location: Right side of wrong
Send a message via AIM to twoodcc Send a message via MSN to twoodcc
ususally when you get "command not found", that means that mysql is not installed.
__________________
tville
Smarter than the average bear
twoodcc is offline   0 Reply With Quote
Old May 15, 2009, 05:23 PM   #5
HiRez
macrumors 601
 
HiRez's Avatar
 
Join Date: Jan 2004
Location: Western US
Or it's installed but it's somewhere that's not in the system PATH list. See http://dev.mysql.com/doc/refman/5.0/...variables.html. You'll probably have to modify a text file to have this set when you log in. You can add it in Terminal but it won't stick when you log out otherwise. Make sure if you use a GUI editor for this that it's plain text only or supports editing plain text (such as TextWrangler, BBEdit, TextMate, etc.). Do not use TextEdit or Microsoft Word unless you're sure you're saving in plain text.

Before doing this, as a test, try running this:

Code:
/usr/local/mysql/bin/mysql
__________________
Go outside, the graphics are amazing!
HiRez is offline   0 Reply With Quote
Old May 16, 2009, 06:57 AM   #6
Winni
macrumors 68030
 
Winni's Avatar
 
Join Date: Oct 2008
Location: Germany.
For starters, you can also download and install the MySQL GUI Tools from the MySQL website and use those. The MySQL packages also include a startup item for the MySQL server and even a small GUI interface to start and stop the MySQL server from the System Preferences menu. You don't need to spend your time on the command line.

However, on the long run, you --have to-- learn how to use and configure the UNIX shell. And you should do so before you even think about learning MySQL itself. There are so many things that can only be done on the shell level, so there is just no way around it.
__________________
Coming soon: http://endnacht.de.
Winni is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > OS X > Mac OS X Server, Xserve, and Networking

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
How do I install my GTX 680 Mac Edition into the Mac Pro? Mac Pro 2009 Mac Pro 5 Feb 6, 2014 02:01 PM
programming with mySQL on mac snoopy531 Mac Programming 12 Aug 5, 2013 12:28 PM
Starting up MySQL on mac on boot estorstenson OS X 7 Jun 7, 2013 02:38 PM
Install Mac OS X 10.6 on New 2012 Mac Mini kitsune_akki Mac mini 9 Nov 16, 2012 06:21 AM
My Mac won't install anything else than Leopard after clean install nampramos MacBook Pro 3 Jul 29, 2012 09:22 AM

Forum Jump

All times are GMT -5. The time now is 07:29 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC