What app (for a beginner) to use to learn/work with MySQL?

programming
1

Hello All,
I’m just starting to learn MySQL and was wondering which app you recommend I work in (GUI).

I don’t know php but want to get into it once I understand databases and how they work.

I’m very comfortable working an Abobe/Macromedia style GUI (if that helps), but not-so much in Visual Studio.

Oh yeah, I’m working on a Mac:OS 10.3.9

Thanks in advance for all your help!
Cheers!

2

phpMyAdmin… it’s a web-based tool, but it shows you all the sql code, and also gives you a gui to work with things.

It’s very easy to install. :slight_smile:

3

Yeah I’ll second phpMyAdmin. Like nokrev said it’s great because it shows you the code – which can help you learn how to work with MySQL.

You may want to grab MySQL Administrator to while you’re at it. It’s not necessary and won’t help you learn like phpMyAdmin will, but it’s a nice tool to help with the administration side of things: setting up users, working with various mysql.ini variables, check server logs, etc.

Edit:

Shoot forgot to post the link to MySQL Administrator for you: http://dev.mysql.com/downloads/administrator/1.1.html

Oh and phpMyAdmin: http://www.phpmyadmin.net/home_page/downloads.php

Not like you couldn’t find them or anything, but it’ll save ya second or two. :slight_smile:

4

Yeah, agree about Mysql admin.

5

Off topic:
Hey nokrev… I feel like I’m following you around the board right now!

7

Thanks all! :smiley:
I really appreciate your time and words.

8

Yeah phpmyadmin is great:D

9

Navicat is the best MySQL GUI that I have worked with. Ofcourse it isn’t free, but you can get the trial of it, and you wont be disappointed. Has everything and is totally worth it. Check it out and youll see it has many more capabilities than any other one out there.

10

I :love: Phpmyadmin, It so simple to use. (-: