When it comes to cPanel database management, a lot of people are quite wary to deal with the phpMyAdmin software tool. This is particularly true amongst new cPanel users. However, this PHP-written tool, which is designed for MySQL administration through a web browser, is actually quite easy to use, as long as you give yourself some time to get accustomed to it. Besides, there are just a lot of things you can do with MySQL through phpMyAdmin.
Aside from database management, you can also use phpMyAdmin to handle tables, relations, fields, permissions, indexes, and users among many others. All the while, you can still execute any type of SQL statement while using this tool. And the best part about this is that, you can access it straight from your cPanel account.
So to help you have an easier, more pleasurable time using this PHP-written tool, take a look at the following tips.
Getting Started: Databases and Users
You need to create a database from cPanel in order to start using phpMyAdmin. Once you have, you can begin managing your databases from cPanel.
Selecting and Viewing Databases
Checking the structure of your existing databases can be done by simply clicking on the name of the database you want to view, which can be found in your home page’s left column. There is also a databases tab on the top of the screen you can click on. Doing this is going to bring up details about that database’s structure. The structure is comprised of individual table names that make up that database.
Browsing Your Databases
Upon selecting a database, you can find out more about it by hitting on the first icon below “action,” just beside the name of the table. The “Browse” view provides you with information about data, by displaying them in rows. You are also going to find a link there for creating a PHP code, which is hyperlinked as “Create PHP Code.” To navigate through all these rows, you can just hit on the “>” or the “>>” buttons. You can also choose a specific page number by selecting the appropriate one from the drop-down menu.
Viewing Your MySQL Processes
To check up on your current MySQL processes, just click on the “Status” tab found on your phpMyAdmin home page. If you want to stop a process, just click on the “kill” link found at the left side of the process ID number.
Logging into Your phpMyAdmin Account
To get logged in to your phpMyadmin account, just perform the following steps:
By hitting the “phpMyAdmin” icon, you automatically get logged in to your phpMyAdmin account.
In the event that you have a web developer on your team, you should consider giving them ccess to your phpMyAdmin account. Instead of providing them with your access data for cPanel, you can just install a separate phpMyAdmin installation so that they do not have to access your cPanel account to do so.