|May 14, 2009, 07:00 PM||#1|
MYSQL on Mac: How to install and use?
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.
|May 14, 2009, 11:07 PM||#2|
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
Smarter than the average bear
|May 15, 2009, 05:23 PM||#5|
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:
Go outside, the graphics are amazing!
|May 16, 2009, 06:57 AM||#6|
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.
|Thread Tools||Search this Thread|
|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|
All times are GMT -5. The time now is 02:19 AM.