MySQL

MySQL is an open-source relational database management system (RDBMS). MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses.MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Flickr, MediaWiki, Twitter, and YouTube.

MySQL logo

Lessons

1. Introduction

Additional Activities

1. Install MySQL Server, you can follow b:MySQL/MySQL_Practical_Guide
2. Connect to database server: mysql -u USERNAME -p PASSWORD -h HOSTNAMEORIP DATABASENAME
3. Tune MySQL Server using mysqltuner perl script
4. List available plugins mysql> show plugins;
5. Show processlist mysql> show processlist;
6. Show tables: mysql> show tables;
7. Create MySQL Backup

See Also

• Category:MySQL
• Databases
• Information system modelling
• Wikipedia: MySQL
• Wikibooks: MySQL
• Web Design/Dynamic Websites/Creating Database Tables
• MediaWiki Engine
• Apache MySQL PHP on Mac OS X
• MariaDB, MySQL fork from former developers after Oracle acquisition

External Links

• MySQL database website
• Planet MySQL - an aggregation of MySQL-related blogs
• MySQL Forge
• MySQL Users Conference
• MySQL General Purpose Stored Routines Library
• MySQL 5.1 testing environment

Documentation:

• MySQL Manual
• MySQL Roadmap
• MySQL blog Articles
• Download MySQL Databases
• #mysql channel documentation wiki
• MySQL Gotchas description of many features in MySQL, which work as advertised, but not as those used to other databases may expect

Other:

• Blog by Peter Zaitsev/Vadim Tkachenko on MySQL Performance Optimization
• Database Journal articles on MySQL
• A Gentle Introduction to SQL By Andrew Cumming - School of Computing, Napier University, Edinburgh, UK. 1999-2005 (Available in Albanian, German, Spanish, Chinese, French, Italian and Portuguese)
• phpMyAdmin - Effective MySQL Management (Open source, browser-based, php5 support, supports MySQL 4.1 and MySQL 5.0)
• w3resource.com MySQL Tutorial - Comprehensive MySQL Tutorial (With hundreds of PHP-MySQL code examples)
• hackr.io MySQL Tutorial - MySQL tutorials voted by the community (Ask your question to 10K+ registered Programming Experts)
• MySQL Reference