Let’s go through all the columns inside the table section generated by the “ Structure ” tab. This area of phpMyAdmin is also referred to as the “ Structure ” tab of an individual database. This action takes you to the specific database management tab where you can see all the tables in the selected database listed in a conveniently structured table view. To select a database, please click the corresponding database name under the “ Database ” column. Now that you have expanded all the available options on this tab, it's time to select a database and start managing it! Overhead - This is a temporary disk space that the database used to run queries.Total - This column contains the total size of the database.Indexes - This column contains the size of the indexes only.Data - This column displays the size of the database, excluding the indexes.Rows - This column contains information about the numbers of rows the database has.Tables - This column shows the number of tables the database has.Clicking it adds more columns to the table shown above, providing additional information. Underneath the table section, you can see the “ Enable statistics ” button. Action - This column contains a “ Check privileges ” button, allowing you to see the privileges of this specific database.Collation - Displays the collation of the database.Database - Displays the name of the database.Here is a description of all the columns: Once you click there, you can see a list of all the databases on the server placed within a table section. To access the functionality allowing you to manage your databases, please, access the first “ Databases ” tab. Once logged in, please navigate to the “ Database ” section and click on the “ phpMyAdmin ” icon.Ĭlicking on the result redirects you to the “ PHPMyAdmin ” feature allowing you to start managing your databases. To do so, please check our tutorial on How to access the cPanel service. Let's get started!īefore you can access the PHPMyAdmin feature, you need to log inside your cPanel account with us. In this tutorial, we will go over all the tasks you can perform on a database using the phpMyAdmin feature inside the cPanel service. In this shape, it can be effortlessly controlled, organized, and managed with the help of the SQL programming language. This electronic information is commonly stored within a grid to accommodate ease of access and make the processing of data more efficient. This structured information, the application using it, and the DBMS can be looked at as the " database system " or in short - the " database ". A database is usually controlled by a database management system ( DBMS ) - in the case of this tutorial phpMyAdmin. ![]() A database is an ordered collection of arranged information stored electronically in a computer's file system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |