Specialization

Technology Expertise

MySQL

MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.

Setting Up MySQL in CPanel

There are many different types of control panels that your shared hosting provider may have. I am using the most popular, CPanel.
First, find the link that allows you to administer MySQL. Within CPanel the icon is labeled MySQL Databases. Once there, you will need to do the following before you can start using MySQL.

  • Create a new database
  • Create a new user with password
  • Assign the user to the database

Tool - phpMyAdmin

Also supplied by most hosting services is phpMyAdmin(we can also install it anywhere we want,
as it’s open source and free). This tool will allow us to view all the MySQL database, tables,
and entries, as well as perform SQL queries remotely through a web browser.

It’s easy-to-use interface will allow us to do many common MySQL tasks quickly and easily,
saving our many beginner headaches and helping us to understand what’s going on in a more visual manner.

A MySQL database is nothing in itself. Rather a MySQL database is a way of organizing a group of tables. If we were going to create a bunch of
different tables that shared a common theme, we would group them into one database to make the management process easier.