What is MySQL and how do I use it?

MySQL is an open source, relational database management system often used in conjunction with scripting languages such as Perl, PHP, etc.

To create a MySQL database:

1) Log in to the control panel for your domain.
2) Click on DATABASES.
3) Click "Add New Database"
4) Enter the database name that you want to create. PLEASE NOTE: The name has to be unique on the server, so you might not always be able to use your first choice.
5) Click on OK.
6) Enter a username that you want to create to be used with the database.
7) Enter a password and confirm the password.
9) Click on OK

You can maintain your database(s) using phpMyAdmin, which is built into the Plesk control panel.

1) Log in to the control panel for your domain.
2) Click on DATABASES.
3) Select the database that you want to modify.
4) Click on DBWebAdmin.

For more information on using phpMyAdmin, please refer to phpMyAdmin's Configuration and FAQ pages at:

http://phpmyadmin.sourceforge.net/documentation/#config

For more information on MySQL, try these resources:

MySQL (official site) 

Beginning MySQL Tutorial (DevShed) 

Website Database Basics With PHP and MySQL (DevShed)

Build your own Database Driven Website using PHP & MySQL (SitePoint)

  • 14 Users Found This Useful
Was this answer helpful?

Related Articles

What is FTP and how do I use it?

Transferring of your website files to our servers can be handled either by FTP (File Transfer...

How do I upload my Website Files?

There are two ways that you can upload files to your website. You can use either the Control...

What are Subdomains?

Most of our hosting accounts come with a number of Subdomains accessible. You can create new...

What file backups should I keep?

For static websites, you should always keep at least one complete copy of your website on your...

What is PHP?

PHP is an open source, server-side, cross-platform, HTML embedded scripting language that is...