Jump to content

MySQL

From Wikiversity
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]
[edit | edit source]

Documentation:

Other:

References

[edit | edit source]
  1. ↑ Wikipedia: MySQL
  2. ↑ https://github.com/major/MySQLTuner-perl
Retrieved from "https://en.wikiversity.org/w/index.php?title=MySQL&oldid=2667592"