Database Panel Information
The Database panel of your cPanel Hosting account is not going to be the first place you start out working with, but it is something you should be familiar with when managing your web sites.
It has 4 icons that offer different functions. For the most part, though, you should first use and access the Database functions with the assistance of customer service of your Web host. That ensures that a well trained and qualified MySQL and PHP admin service rep is there to help you out and avoid any errors. You don’t want to screw up the database to your web site if you can avoid it.
This is the area that allows you to create and manage your databases. Here is the web host definition of the function. MySQL Databases allows you to store lots of information in an easy to access manner. The databases themselves are not easily read by humans. MySQL databases are required by many web applications including some bulletin boards, content management systems, and others. To use a database, you’ll need to create it. Only MySQL Users (different than mail or other users) that have privileges to access a database can read from or write to that database.
You can create a database in this section. You can define who gets access to a specific database if you want to add anyone. And you see the list of active databases you have along with a list of users who have access to your account.
MySQL® Database Wizard
This is a function that allows you to create a database. It replicates the same function available in the previous icon. It is a convenient way of just focusing in on adding to your database list without all the other distractions of the MYSQL Database main page.
This is the area where you manage the different individual tables of a database. Unless you are familiar with database management, I would leave this area to a trained customer service rep of your web host if you want to go change anything.
The one thing you can do is select a database and go into the wp_options file to see which specific web site that database refers to. I don’t always remember which database code refers to a specific website and going into phpMyAdmin for a particular database and selecting the options file will tell me which web site that database belongs to.
You can allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site. This is something you may need later, but when starting out I would not worry about remote access.
The Database panel is something you should become familiar with over time. At the outset I would recommend working with your databases through customer service until you are comfortable with knowing how to manage and edit files.
I hope this has been helpful. If you want more information to see how to use Databases, check out my video.
Stay with it, stay well and May Your Travels Be Prosperous.