MySQL on comp.uark.edu and cavern.uark.edu

cavern.uark.edu is the official web server of the University.

NOTE: comp.uark.edu is NOT a production server. It may be restarted occasionally for maintenance without notice, so there may be times when the MySQL server is unavailable.

Users must request an account in order to access the MySQL server. Use the MySQL Request Form available from UITS Request forms and Documents to get your MySQL account.

MySQL Account Guidelines

• Use of the MySQL Server is limited to those users who have accounts on comp.uark.edu.
• Users are provided with one (1) username to access the MySQL Server, with one (1) database where SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, and DROP privileges are provided.
• Each user is given permissions to only his/her database and a "test" database, to which all users have access.
• Users are allowed to connect to the MySQL Server only from localhost (comp.uark.edu).
• Use of  phpMyAdmin (an Open-Source Graphical Interface) is provided to allow a more user-friendly method to interface with the MySQL Server.
  phpMyAdmin on cavern
  phpMyAdmin on comp

What is MySQL?

MySQL is one of the world's most popular open source relational database servers. Relational databases are like electronic filing cabinets for large volumes of complex data, which can be accessed through a standard language called SQL (Structured Query Language). SQL is pronounced either "sequel" or "ess-que-ell" which is the preferred form.

A relational database provides a simple method for gathering specific or large amounts of data, maintained in a structured form. Examples of applications that are light-weight databases include Microsoft Access and FileMakerPro. Examples of serious relational database servers include Oracle, Sybase, DB2, or MS SQL Server. MySQL has found its place as a fast, easy to use, scalable, and free database server, which has many benefits for general applications.

Any questions regarding MySQL can be directed to jmkeith@uark.edu.