MySQL Resources

MySQL is a free, open-source relational database that has been used in thousands of websites, large and small. This is a contributed collection of resource links on MySQL. Feel free to add your favorites.

• Mike Franks – SSC
  • Collection of Mysql links and articles http://www.sscnet.ucla.edu/mysql/
  • Notes while learning Mysql http://www.sscnet.ucla.edu/mysql/notes.htm
  • Article on GRANTing access http://www.devshed.com/Server_Side/MySQL/Access/print_html
  • Article I don’t understand on storing hierarchical data in a relational database. //would this work with Mysql?\\ http://www.oreillynet.com/pub/a/network/2002/11/27/bioconf.html
  • Quick Tips to Optimize MySQL
• Ian Roessle November 9, 2002 at 13:23:
  • Here is a link to a sourceforge project written in PHP to manage Mysql databases from the web. Very useful tool. http://phpmyadmin.sourceforge.net/
• Client-side database tools
  • Aqua Data Studio is a database query and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. My favorite features: auto-completing SQL editor, and Excel-like editing of SELECT resultsets – the software generates automatically the appropriate UPDATE commands. Written in Java and supported on Windows, OS X, Solaris and Linux. Comes with JDBC drivers for MySQL, MS SQL Server 7/2000, Oracle 8/9/10, PostgreSQL and Sybase, and you can add drivers for other DBs. Runs fast. Free for educational use.
  • DBDesigner4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. I use it to visually layout and plan my database schemas. Free. Only on Windows and Linux
  • Point-and-Click MySQL Adminstration – Linux Magazine – Feb. 1, 2007
  • The MySQL Query Browser – Linux Magazine – April 19, 2007

This article was originally posted on the UCLA Programmers Wiki.