This is the MySQL Resources for Developers

MySQL IDE's

MySQL Turbo Manager
http://www.mentattech.com

MySQL Manager
http://ems-hitech.com/mymanager

MySQL-Front
http://www.mysqlfront.de

DbVisualizer
http://www.ideit.com/products/dbvis

MySQL WebAdmin

PHPMyAdmin
http://www.phpmyadmin.net/home_page

MySQL Datamanager
http://www.edatanew.com

TOAD for MySQL Preview Release
http://www.quest.com

Tutorials

SQL Tutorial
http://w3.one.net/~jhoffman/sqltut.htm

MySQL and PHP Tutorial
http://www.vtwebwizard.com/tutorials/mysql/index.html

Perl/MySQL Tutorial
http://www.hotwired.com/webmonkey/b.../tutorial1.html

MySQL Basics
http://www.analysisandsolutions.com/code/mybasic.

Books Resources

MySQL Pocket Reference
Author(s): George Reese
Publisher: O'Reilly & Associates, Inc.

High Performance MySQL
Author(s): Jeremy Zawodny, Derek J. Balling
Publisher: O'Reilly & Associates, Inc.

MySQL Enterprise Solutions
Author(s): Alexander Pachev
Publisher: Wiley, John & Sons, Incorporated

Regards,

Hi ptesone, thank you for the list.

Now we can redirect all where-can-I-learn-about-MySQL questions to this thread. =)

I wonder if this forum supports "sticky" posts though... that way we can build a FAQ thread or something and don't have to tell people to search for the past postings.

Just a thought.

Sticky ideas sounds fantastic to me, and I've requested it with the higher beings.

Another good MySQL tutorial site:
http://www.juicystudio.com/tutorial/mysql/index.asp

Secure Vars - http://www.phprebel.org/tutorials/code/secure.VARS/secure.VARS.phps

This is one of my favorite pages. It contains short, good quality tutorials on many topics - on SQL as well. Absolutely worth of visiting at least for the beginners.

http://www.w3schools.com/

Bit of a typo there...?
Useful MyQl Resources

An excellent GUI program for MySQL administration called MySQL Maestro.

http://www.mysqlmaestro.com

I have tried MySQL Maestro and it worked very slow compared with other GUI. While doing the migration, my computer was hang and it forced me to restart the computer.

It is expensive and full of bugs. I would perfer to use Phpmyadmin at this moment.

Cazz

I agree I see no reason to change to MySQL Maestro when PHPmyadmin fits and serves all of my database needs, despite my occasinal use of flat files.

Although I like Phpmyadmin so much and definitely not ready to pay for another application, I would still like to recommend a software named Navicat, http://www.navicat.com

I didn't encounter this software until I read this article: http://www.geocities.com/mchuthor/review.html

Cazz

Navicat is nifty looking and very intuitive to use. Plus it has a GREAT tool called data transfer to move entire DBs or partially directly from any server to any other server.
Produces sql dumps of whole DBs or tables, etc, handles users perfectly and can migrate from Excel, Access etc.
BUT it chokes big time on large DBs (large= 50MB .sql dump or >60K entries of decent size). So if you don´t have large DBs pay heed to cazzoot and check this soft out.

mySQL control center has given me lots of trouble trying to reconfig users (doesn´t fulsh or something) "other than that" just fine :P

For large transfers I go to console: mysqldump --opt ....

Speaking of which,
do any GUIs you use handle large DB transfers?
php my admin works great since it is server side but i find it flaky sometimes.

And BEST site ever: Dark Freak speaks the truth:
http://www.w3schools.com/

This is one of my favorite pages. It contains short, good quality tutorials on many topics - on SQL as well. Absolutely worth of visiting at least for the beginners.

http://www.w3schools.com/

spent two hours on this site last night, most productive two hours since i began study of html, thank you very much!

MySQL SNMP Agent and Web Console

http://www.adventnet.com/products/mysql_agent/

Provides out-of-the-box ability to monitor and manage the various components of MySQL database such as users, queries, performance, logs, etc. Comes with a Web console for remote monitoring and an SNMP interface to integrate with HP OpenView, IBM Tivoli, etc.

Tool that generates PHP pages for your mySQL database... actually generates your choice ASP or PHP and works with most databases. A real time saver, and good tutor too.

dbQwikSite www.dbQwikSite.com (http://www.dbqwiksite.com)

I have tried most of the IDE suggested above, however, none of them provide a good Import functionality that let me import my Access database to MySQL.

I came across a program called Navicat, http://www.navicat.com and downloaded a trial version. This GUI offers a feature-rich import/export wizard and other advanced database admin options.

I am still evaluating other features of Navicat. Apparently, it seems the best MySQL GUI in the market.

If you haven't tried it before, I suggest you to check out a review by O'Reilly.
http://www.onlamp.com/pub/a/onlamp/2004/12/22/navicat.html

You forgot MySQL Administrator and MySQL Query Browser. Aswell as the MySQL Manual!

Hello,

Check this mysql manual is the best for mysql 5 features :
http://www.mysqldevelopment.com

Check the new GUI MySQL Turbo Manager 3.4 , support all mysql 5 features like triggers, stored procedures and views.
http://www.mentattech.com

Check the new MySQL Server 5.0.12.
http://dev.mysql.com/downloads/mysql/5.0.html


Enjoy

Hey guys, I came across this awesome plugin chat for phpnuke sites, check it out if you have a chance! http://www.userplane.com/webchat/

Hi,

New resources for MySQL 5 server :


Database 5

http://dev.mysql.com/downloads/mysql/5.0.html

GUI'S
MySQL Turbo Manager
http://www.mentattech.com

SQLyog
http://www.webyog.com

Papers

Stored Procedures
http://dev.mysql.com/tech-resources...procedures.html
Triggers
http://dev.mysql.com/tech-resources...l-triggers.html
Views
http://dev.mysql.com/tech-resources...ysql-views.html

BOOKS

Pro MySQL from
http://www.apress.com/book/bookDisplay.html?bID=433

The Definitive Guide to MySQL 5
http://www.apress.com/book/bookDisplay.html?bID=10011

Regards,

MySQL resources. Also there's lots of tutorials about Actionscript, Javascript, PHP.

follow this link Online Scripts (http://scripts.hrhosting.net)

Moved this to database. Maybe someone can sticky this again?

Moved this to database.Good thought, should of been moved sooner. :) Maybe someone can sticky this again?
Done. :)

An alternative to Navicat is HeidiSQL. Freeware, seems to work fast. It's got my vote!


http://www.heidisql.com/

A MySQL GUI for Mac OS X (CocoaMySQL), that i've been using for years

http://cocoamysql.sourceforge.net

CocoaMySQL as been replaced by Sequel Pro (http://code.google.com/p/sequel-pro/), but it is only available for mac OS 10.5

For 10.4-10.3 you can still find CocoaMySQL here (http://sequel-pro.googlecode.com/files/CocoaMySQL-pre0.7b6.zip)