bchmautic

Troubleshoot phpMyAdmin timeout errors

NOTE: We are in the process of modifying the file structure and configuration for many Bitnami stacks. On account of these changes, the file paths stated in this guide may change depending on whether your Bitnami stack uses native Linux system packages (Approach A), or if it is a self-contained installation (Approach B). To identify your Bitnami installation type and what approach to follow, run the command below:

 $ test ! -f "/opt/bitnami/common/bin/openssl" && echo "Approach A: Using system packages." || echo "Approach B: Self-contained installation."

The output of the command indicates which approach (A or B) is used by the installation, and will allow you to identify the paths, configuration and commands to use in this guide. Refer to the FAQ for more information on these changes.

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.

#1045 error when logging in

This error occurs because you probably changed the default password for the bitnami account when building a new server, and phpMyAdmin’s configuration is not updated with your chosen password value. Resolve it by following the steps below:

  • Log in to the server console via SSH.

  • Edit the phpMyAdmin configuration file.

    NOTE: Depending on your installation type, you can find the phpMyAdmin configuration in the following locations:

    • Approach A (Bitnami installations using system packages): /opt/bitnami/phpmyadmin/config.inc.php
    • Approach B (Self-contained Bitnami installations): /opt/bitnami/apps/phpmyadmin/htdocs/config.inc.php
  • Change the default bitnami password to the one chosen during the server build process, by finding the line below and replacing the PASSWORD placeholder with the correct value:

    $cfg['Servers'][$i]['password'] = 'PASSWORD';
    
Last modification June 10, 2020