phpMyAdmin is an easy to use management tool for MySQL that allows you to create and drop databases, create, drop and modify tables, delete, edit and add fields, execute SQL statements, manage keys on fields, manage privileges and export data in various formats through a web-based interface.
How to access phpMyAdmin?
You should be able to access phpMyAdmin directly, by browsing to http://127.0.0.1/phpmyadmin.
The username is root for phpMyAdmin, and the password is the one specified by you during the installation process.
How to change the phpMyAdmin password?
The phpMyAdmin credentials are the same as those used to access the MySQL database. To modify the password, refer to this page.
How to export a database?
Follow these steps:
Log in to the included phpMyAdmin application using these instructions.
Select the application database in the left navigation menu. In this example, the database is named bitnami_wordpress.
Select the "Export" menu item.
On the resulting page, select the "Quick" export method and the "SQL" output format.
An SQL export file will be created and downloaded to your desktop. Store this file carefully, as you will need it if you plan to later import the database back into MySQL.
How to modify the allowed limit for uploaded files?
Modify the following option in the installdir/apps/phpmyadmin/conf/httpd-app.conf file to increase the allowed size for uploads:
<IfModule php5_module> php_value upload_max_filesize 80M php_value post_max_size 80M </IfModule>
If you are using PHP-FPM, modify the settings in the installdir/apps/phpmyadmin/conf/php-fpm/php-settings.conf file
How to modify the execution time?
This parameter sets the timeout for Apache to run a script.
Modify it in the php.ini file.
max_execution_time = 120 ; Maximum execution time of each script, in seconds
Modify the ExecTimeLimit value in the installdir/apps/phpmyadmin/htdocs/config.inc.php file:
$cfg['ExecTimeLimit'] = 120;
To set this execution timeout to be unlimited (apply this value only if really necessary), set the time limit to 0 in both cases.
Timeout error when importing zipped database
If you try to import a zipped database, you might see a timeout error because phpMyAdmin takes too long to execute the script. To fix this:
Set the ExecTimeLimit setting to 0 (infinite) as described here.
Try to import the file again.
Remember to change the ExecTimeLimit setting back to its original value once the import process ends.