Site5 - Built For Designers & Developers MENU
Home  ›  Web Hosting FAQ  ›  Web Hosting: What is a MySQL database?

Web Hosting: What is a MySQL database?

3 Comments

A MySQL database, like all other types of databases, is used to keep track of a website or software’s data.

The technical term for MySQL is a relational database management system, or RDBMS. MySQL is a software program that runs at all times on a server and gives other programs access to the information it maintains.

This information is stored in databases. A database is made up of tables. Each table is structured into fields that can contain a specific type of information; some fields can contain only numbers, while others can only contain dates, etc.

When data is inserted into a table, each group of fields is called a row.

MySQL controls access to this information with usernames and passwords, just like when you log in to a computer. Each username gets permission to do certain things with certain databases.

You can create MySQL databases, users, and passwords inside your control panel.

If you plan to install web software on your hosting account, you’ll need at least one MySQL database. Most web software is designed to share a single database with more than one other software program.

You’ll also need to create a username and password for the software to use. Be sure to make the password as complex as possible, because it’s not a password you’re going to need to remember. Usually, a program will store its MySQL password in a configuration file; you’ll never need the password again after installation.

Still have a question? Or need help?
See an error in this article or want to suggest a missing topic? Please leave us a comment below! If you need technical support with your account, please email us, chat live with a representative, or call us!

3 Comments

  • You better remember or keep track of your database password if you are using a CMS.
    Just ask me as I try to migrate a Joomla site.
    Klaus Iden

  • Make the MySQL port number easier to discern please. that is the opening in the server… the server part that talks database so that scripts can connect to it.

    • Hello Sam,

      We run MySQL on the default port of 3306. Most scripts should not need this, though.

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.