MySQL

From Wikiversity
Jump to navigation Jump to search
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_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]

External Links[edit | edit source]

Documentation:

Other:

References[edit | edit source]