School:Computer Science → Topic:Computer Programming → Topic:Databases → Topic:MySQL

What is MySQL?

MySQL is a multithreaded, multi-user, SQL Database Management System. It is often accessed and managed through PHP-driven content management systems. (MediaWiki, the wiki engine for Wikiversity is an example of a system that uses MySQL.)

The open source MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most of the codebase. Both the MySQL server software itself and the client libraries are distributed under a dual-licensing format. (MediaWiki deploys MySQL under the GNU General Public License).

Prerequisites

Learners interested in MySQL may wish to enroll at Databases and Web Design.

  1. Introduction to Databases
  2. Database Management Systems
  3. Introduction to SQL
  4. Introduction to PHP

Object-relational databases and MediaWiki are advanced related topics under develpment. You might want to take a peek.

Activities

  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[1]
  4. List available plugins mysql> show plugins;
  5. Show processlist mysql> show processlist;
  6. Show tables: mysql> show tables;
  7. Create MySQL Backup

Learning materials

Search for MySQL on Wikipedia.
Wikibooks has a book on the topic of MySQL.

Wikiversity lessons:

Resources

Documentation:

Other:

References

  1. ↑ https://github.com/major/MySQLTuner-perl
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.