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.^[1]

1. Introduction

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^[2]
4. List available plugins mysql> show plugins;
5. Show processlist mysql> show processlist;
6. Show tables: mysql> show tables;
7. Create MySQL Backup

• 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

• 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