Knowledgebase: MySQL
MySQL Overview
Posted by on 02 July 2012 01:22 PM

MySQL is the world's most widely used open-source relational database management system that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius's daughter, My. The SQL phrase stands for Structured Query Language.

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. LAMP is an acronym for 'Linux, Apache, MySQL, Perl/PHP/Python'. LAMP is what most popular Content Management Systems, like Wordpress, Joomla, Drupal and osCommerce, store most of their stuff.

In a cPanel environment, a MySQL Database can be created in the MySQL Databases module.

Once a database is created, make sure a database user is created and its privileges are assigned in order to be able to use the database. Database structure can be directly managed through phpMyAdmin, which is also embedded in cPanel under it's own module. 

See also Set Up cPanel MySQL Database and User, Move Your WordPress Site to A Small Orange



Attachments 
 
 mysql_databases.png (27.32 KB)
(3 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion
ERROR: This domain name (kb.asmallorange.com), does not match the domain name in the license key file help.asmallorange.com.

For assistance with your license, please contact the Kayako support team: https://support.kayako.com