|May 14, 2009, 08: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 15, 2009, 12:07 AM||#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, 06: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, 07: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.
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|IPHONE 4 how to JAILBREAK AND UNLOCK||bs2511feist||Jailbreaks and iOS Hacks||6||Apr 14, 2012 06:52 PM|
|How to install SL using Time Machine?||tianji||OS X||5||Aug 31, 2009 04:19 AM|
|How to Install Themes / Use Winterboard with 3.0?||LissiSays||Jailbreaks and iOS Hacks||11||Jun 26, 2009 08:00 PM|
|Easy way to install and use MEncoder and FFmpeg?||tbluhp||Mac Applications and Mac App Store||2||Oct 15, 2008 02:58 PM|
|How to install and crack program on mac 9.2||pav_ell||Wasteland||2||Oct 7, 2004 05:24 AM|
All times are GMT -5. The time now is 03:07 PM.