MySQL

Introduction

MySQL is (as of July 2013) the world's second most widely used relational database management system (RDBMS) and most widely used open-source RDBMS. It is named after co-founder Michael Widenius's daughter, My. The SQL acronym stands for Structured Query Language.

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL.

For proprietary use, several paid editions are available, and offer additional functionality. Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook, Twitter, Flickr, and YouTube.

Usage

You may connect to the CSE MySQL servers from any machine that has a mysql client binary.

Compute Systems Invocation Version(s)
Red Hat Linux (64-bit) % /util/bin/mysql -h tethys -p 5.1.63 (default)

CSE MySQL Instances

CSE hosts MySQL instances for these constituencies:

Server Constituency Server Version
tethys CSE, CEN, BCS students 5.1.63
postel CSE faculty and staff 5.1.63
paganini Aidong Zhang's research 5.1.47
oceanus Marianne Sullivan's projects 5.1.57
alice Request Tracker (RT) server 5.1.46

Notes

  1. If you're a CSE student and you need a MySQL account, contact cse-consult@buffalo.edu.
  2. When you get your new account, change your default password to a password only you know:

    
    mysql> set password = password('MyPassw0rd');
    
    

References

  1. http://en.wikipedia.org/wiki/Mysql
  2. http://www.mysql.com/
  3. http://dev.mysql.com/doc/refman/5.1/en/index.html
  4. http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html
  5. http://code.google.com/p/google-mysql-tools/wiki/Mysql4Patches
  6. http://www.alentus.com/hosting/mysql.asp
  7. % man mysql