# 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 – <span class="caps">SSC</span>
    - Collection of Mysql links and articles [http://www.sscnet.ucla.edu/mysql/](http://www.sscnet.ucla.edu/mysql/)
    - Notes while learning Mysql [http://www.sscnet.ucla.edu/mysql/notes.htm](http://www.sscnet.ucla.edu/mysql/notes.htm)
    - Article on GRANTing access [http://www.devshed.com/Server\_Side/MySQL/Access/print\_html](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](http://www.oreillynet.com/pub/a/network/2002/11/27/bioconf.html)
    - [Quick Tips to Optimize MySQL](http://www.linux-mag.com/id/2976/)
    - [8 Reasons Not to Use MySQL](http://www.cio.com/article/113111/Eight_Sound_Reasons_Not_to_Use_MySQL)
    - [5 Reasons To Use MySQL](http://www.cio.com/article/113110)
- Ian Roessle November 9, 2002 at 13:23: 
    - [phpMyAdmin](http://phpmyadmin.sourceforge.net/) is a very useful tool for managing Mysql databases from the web. And this article tells how to [Turn on phpMyAdmin’s hidden features](http://blog.ht4.ca/2009/12/29/hidden-phpmyadmin-features/)
- Client-side database tools 
    - [Aqua Data Studio](http://www.aquafold.com/) is a database query and administration tool that allows developers to easily create, edit, and execute <span class="caps">SQL</span> scripts, as well as browse and visually modify database structures. My favorite features: auto-completing <span class="caps">SQL</span> editor, and Excel-like editing of <span class="caps">SELECT</span> resultsets – the software generates automatically the appropriate <span class="caps">UPDATE</span> commands. Written in Java and supported on Windows, OS X, Solaris and Linux. Comes with <span class="caps">JDBC</span> drivers for MySQL, MS <span class="caps">SQL</span> 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](http://www.fabforce.net/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](http://www.linux-mag.com/id/2886/) – Linux Magazine – Feb. 1, 2007
    - [The MySQL Query Browser](http://www.linux-mag.com/id/3051/) – Linux Magazine April 19, 2007
- Server-side Admin 
    - [Performance Tuning Best Practices for MySQL – Google Tech Talks – 43 min – Apr 28, 2006](http://video.google.com/videoplay?docid=2524524540025172110) *Recommended by Harry Mangalam, <span class="caps">UCI</span> on [UC-<span class="caps">CSC</span> Mailing List](https://maillists.uci.edu/mailman/listinfo/uccsc) “This is a bit dated, but since so many web services use MySQL, this may still be useful.. It’s 43 min long, but the guy has a lot of useful hints and if you let it run in the background, you’ll pick up some things that will help, especially if you’re confused about the diffs between myisam and innodb tables and how to tune each.”*
    - [Quick and Dirty MySQL Performance Troubleshooting](http://www.linux-mag.com/cache/7473/1.html) – Jeremy Zawodny, Monday, August 17th, 2009 [Linux Magazine](http://www.linux-mag.com/)
- General documentation and training 
    - [MySQL University](http://forge.mysql.com/wiki/MySQL_University) provides free download of talks on various topics.
    - [Be productive with the MySQL Command Line](http://www.mysqlperformanceblog.com/2012/12/21/be-productive-with-the-mysql-command-line/)
    - [Fun with the MySQL pager command](http://www.mysqlperformanceblog.com/2013/01/21/fun-with-the-mysql-pager-command/)

*This article was originally posted on the <span class="caps">UCLA</span> Programmers Wiki.*