mysql on mac for a beginner
Author
Discussion

pcowen

Original Poster:

401 posts

297 months

Wednesday 22nd August 2007
quotequote all
I want to learn mysql using online tutorials, to do some basic apps building. I'm looking at mysql, I've followed many instructions about downloading and installing, which I think I've completed. I seem to have mysql server running see image. But in the many tutorials I've looked at they jump straight into using what I can only think is an application called 'terminal' on a mac. I open this and that's where following the tutorial fails. How do I know mysql is running and where?

Does anyone know a complete step by step, click by click tutorial to follow for beginners? or does anyone have this set up and can give me some pointers?



pcowen

Edited by pcowen on Wednesday 22 August 11:57

xiphias

5,889 posts

258 months

Wednesday 22nd August 2007
quotequote all
Have you tried looking in activity manager to see if there is a mysql daemon?

tigger1

8,486 posts

252 months

Wednesday 22nd August 2007
quotequote all
sqlzoo.net has a few basic things that you can do online. Ok, the tests are a bit noddy...but it's a good start until you get your server up and running.

Also http://www.w3schools.com/sql/default.asp is pretty good too (no online jiggery pokery there though, just tutorials)

Can't help with the Mac issue though.

TheLearner

6,962 posts

266 months

Wednesday 22nd August 2007
quotequote all
It's running. It says it is.

Open terminal, type mysql and then press enter.

You should see a prompt that looks like '>' that, if so it's sat waiting.

If it bitches about invalid username/password good for a setup guide as you might need to do the equivalent of setting up a root password for it (mysqladmin -u root -h <host> -password '<password>' from memory).

Edit: Welcome to SQL servers 101, have your big stick to hand, you're likely to be eaten by a Grue hehe (translation: other than the tonka toy one MS put out, MySQL, Oracle, DB2 and such are universally unfriendly).

Edited by TheLearner on Wednesday 22 August 14:39

cyberface

12,214 posts

288 months

Wednesday 22nd August 2007
quotequote all
Terminal is a basic command line interface to the unix underbelly of Mac OS X. You'll need some basic knowledge of unix commands to get anywhere with this.

For example, entering 'ps ax' to give a list of running processes should show something like 'mysql' somewhere in the list smile

If you're completely lost at the command prompt then you'll need to get some basic knowledge about the shell, etc. before you start.

The other alternative, assuming the server is running and you've set it up in a normal fashion, is to get one of the many graphical query tools to let you run SQL against the database. The product 'SQLGrinder' was good last time I looked at it.

kiwisr

9,335 posts

238 months

Wednesday 22nd August 2007
quotequote all
TheLearner said:
It's running. It says it is.

Open terminal, type mysql and then press enter.

You should see a prompt that looks like '>' that, if so it's sat waiting.
Presuming it's in the path or has an alias.

Otherwise you'll have to use :

/usr/local/mysql/bin/mysql

or navigate to that directory.

TheLearner

6,962 posts

266 months

Wednesday 22nd August 2007
quotequote all
kiwisr said:
TheLearner said:
It's running. It says it is.

Open terminal, type mysql and then press enter.

You should see a prompt that looks like '>' that, if so it's sat waiting.
Presuming it's in the path or has an alias.

Otherwise you'll have to use :

/usr/local/mysql/bin/mysql

or navigate to that directory.
Last time I did a MAMP install on my old imac, it did the path/alias thing. Of course different versions, minor variations in packaging and such. Still good point smile