mysql on mac for a beginner
Discussion
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
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
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.
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.
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
(translation: other than the tonka toy one MS put out, MySQL, Oracle, DB2 and such are universally unfriendly).
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
(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
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
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.
For example, entering 'ps ax' to give a list of running processes should show something like 'mysql' somewhere in the list

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.
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.Open terminal, type mysql and then press enter.
You should see a prompt that looks like '>' that, if so it's sat waiting.
Otherwise you'll have to use :
/usr/local/mysql/bin/mysql
or navigate to that directory.
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.Open terminal, type mysql and then press enter.
You should see a prompt that looks like '>' that, if so it's sat waiting.
Otherwise you'll have to use :
/usr/local/mysql/bin/mysql
or navigate to that directory.

Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


