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.

Lessons

 * 1) /Introduction/

Additional Activities

 * 1) Install MySQL Server, you can follow MySQL/MySQL_Practical_Guide
 * 2) Connect to database server:
 * 3) Tune MySQL Server using mysqltuner perl script
 * 4) List available plugins
 * 5) Show processlist
 * 6) Show tables:
 * 7) Create MySQL Backup