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]
Lessons
editAdditional Activities
edit- Install MySQL Server, you can follow b:MySQL/MySQL_Practical_Guide
- Connect to database server:
mysql -u USERNAME -p PASSWORD -h HOSTNAMEORIP DATABASENAME
- Tune MySQL Server using mysqltuner perl script[2]
- List available plugins
mysql> show plugins;
- Show processlist
mysql> show processlist;
- Show tables:
mysql> show tables;
- Create MySQL Backup
See Also
edit- Category:MySQL
- Databases
- 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- 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