From Wikiversity
Jump to navigation Jump to search

School:Computer ScienceTopic:Computer ProgrammingTopic:DatabasesTopic:MySQL

What is MySQL?[edit | edit source]

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

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

Wikipedia-logo.png Search for MySQL on Wikipedia.
Wikibooks-logo.svg Wikibooks has a book on the topic of MySQL.

Wikiversity lessons:

Resources[edit | edit source]



References[edit | edit source]