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

**URL:** <https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427>\
**Category:** programming\
**Created:** [April 5, 2006, 2:15am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427 "2006-04-05T02:15:57Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Coolidge](https://avatars.discourse-cdn.com/v4/letter/c/dec6dc/32.png) [@Coolidge](https://forum.kirupa.com/u/Coolidge)\
**Post date:** [April 5, 2006, 2:15am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/1 "2006-04-05T02:15:57Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Jeff\_Wheeler](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@Jeff\_Wheeler](https://forum.kirupa.com/u/Jeff_Wheeler)\
**Post date:** [April 5, 2006, 2:17am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/2 "2006-04-05T02:17:12Z")

</div>

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. 🙂

---

<div class="post-metadata">

**Author:** ![Ankou](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ankou/32/1351_2.png) [@Ankou](https://forum.kirupa.com/u/Ankou)\
**Post date:** [April 5, 2006, 3:12am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/3 "2006-04-05T03:12:05Z")

</div>

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](http://dev.mysql.com/downloads/administrator/1.1.html)

Oh and phpMyAdmin: [http://www.phpmyadmin.net/home\_page/downloads.php](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. 🙂

---

<div class="post-metadata">

**Author:** ![Jeff\_Wheeler](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@Jeff\_Wheeler](https://forum.kirupa.com/u/Jeff_Wheeler)\
**Post date:** [April 5, 2006, 3:12am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/4 "2006-04-05T03:12:36Z")

</div>

Yeah, agree about Mysql admin.

---

<div class="post-metadata">

**Author:** ![Ankou](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ankou/32/1351_2.png) [@Ankou](https://forum.kirupa.com/u/Ankou)\
**Post date:** [April 5, 2006, 3:26am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/5 "2006-04-05T03:26:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jeff\_Wheeler](https://avatars.discourse-cdn.com/v4/letter/j/59ef9b/32.png) [@Jeff\_Wheeler](https://forum.kirupa.com/u/Jeff_Wheeler)\
**Post date:** [April 5, 2006, 3:29am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/6 "2006-04-05T03:29:30Z")

</div>



---

<div class="post-metadata">

**Author:** ![Coolidge](https://avatars.discourse-cdn.com/v4/letter/c/dec6dc/32.png) [@Coolidge](https://forum.kirupa.com/u/Coolidge)\
**Post date:** [April 5, 2006, 4:37am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/7 "2006-04-05T04:37:27Z")

</div>

Thanks all! 😃  
I really appreciate your time and words.

---

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [April 5, 2006, 4:38am UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/8 "2006-04-05T04:38:06Z")

</div>

Yeah phpmyadmin is great:D

---

<div class="post-metadata">

**Author:** ![skOOb](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@skOOb](https://forum.kirupa.com/u/skOOb)\
**Post date:** [April 5, 2006, 12:03pm UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/9 "2006-04-05T12:03:05Z")

</div>

[Navicat](http://www.navicat.com)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.

---

<div class="post-metadata">

**Author:** ![Seb\_Hughes](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Seb\_Hughes](https://forum.kirupa.com/u/Seb_Hughes)\
**Post date:** [April 5, 2006, 9:29pm UTC](https://forum.kirupa.com/t/what-app-for-a-beginner-to-use-to-learn-work-with-mysql/184427/10 "2006-04-05T21:29:20Z")

</div>

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