You can select all the database tables or just pick some of them. In the Export tab, you can export your database tables content in different formats (CSV, SQL, PDF, Microsoft Excel, Microsoft Word, XML, and many more). You can see the traffic handled by the MySQL server, the maximum number of simultaneous connections, the total number of connections, the failed and the aborted attempts, the total number of queries sent to the server and more related details. In the Status tab, you can find detailed information regarding the MySQL server since the last restart.
Just type in the query and click the Go button and the phpMyAdmin tool will execute the query and provide the results from it. Using this tab you can perform a MySQL query towards the MySQL server. You will see a table with the used collations, the number of the tables and the rows, the size of the data and the indexes, the total size and the overhead. Once you click on a chosen database name, you can start managing that database. In the Databases tab, you will find a list with all the databases which can be managed through the database user. In the panel on the left side of the page is the list of the databases for which your user has privileges.Īt the top of the page, you can see different tabs which allow you to perform different actions. In the middle part of the page, in the General Settings section, you can see the MySQL charset and you will be able to define the MySQL connection collation. In the other two sections – Web server and phpMyAdmin you can also see information regarding the MySQL server, the MySQL client and the phpMyAdmin version.
#LOCALHOST PHPMYADMIN SOFTWARE#
The databases which you will manage are stored on the same server as the software and the hostname is – localhost. On the right side of the screen, in the Database server section, you can find information about the MySQL server. This tutorial explains the different functionalities of the phpMyAdmin software, integrated into Site Tools.
0 kommentar(er)
