MySQL

MySQL logo

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]

## Lessons

[edit | edit source]

1. Introduction

## Additional Activities

[edit | edit source]

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

## See Also

[edit | edit source]

* 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

[edit | edit source]

* 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

## References

[edit | edit source]

1. ↑ Wikipedia: MySQL
2. ↑ https://github.com/major/MySQLTuner-perl