phpmyadmin

LARAGON – Add phpMyAdmin

1. Introduction

In a fresh Laragon installation, the default database administration tool is HeidiSQL.

But you can easily add phpMyAdmin to your Laragon installation.

laragon

There are 2 possible ways to add phpMyAdmin to your installation :

  • you could use Laragons build in menu Tools → Quick Add → *phpMyAdmin
  • you could install it manually
phpmyadmin

We’ll explain both ways below.

2. Laragon - Add phpMyAdmin by using Quick add

Before we install phpMyAdmin by using Laragons built-in Quick add procedure, we have to make sure it uses the latest version.
  • In the menu, select ToolsQuick addConfiguration.
  • Replace the line *phpmyadmin= by the (more generic) link to phpMyAdmin latest version : phpmyadmin=https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
  • Then save the file and exit the editor.

Now we can install the latest phpMyAdmin version.

  • In the menu, select ToolsQuick add*phpMyAdmin.
  • After installing phpMyAdmin, http://localhost/phpmyadmin will be opened in a new browser tab or window.
  • In a fresh Laragon installation, the default user is root  and the password is not set.
  • Select your preferred language.
  • Log in to phpMyAdmin by clicking the Go button.

3. Laragon - Add or update phpMyAdmin manually

  • Download the latest phpMyAdmin version as a ZIP archive from phpmyadmin.net into your \Downloads\ folder.
  • The packed file is named for instance phpMyAdmin-5.1.0-all-languages.zip.
  • Unpack the downloaded ZIP archive in a folder with the same name phpMyAdmin-5.1.0-all-languages.
  • Rename the folder to phpMyAdmin.
  • Delete any existing  \etc\apps\phpMyAdmin\ folder of your Laragon installation.
  • Move the complete \phpMyAdmin\ folder from your \Downloads\ folder to the \etc\apps\ folder of your Laragon installation.

In Laragons horizontal Button Menu, you can now click the Database button to open phpMyAdmin.

4. Configure phpMyAdmin

In case you installed phpMyAdmin for the first time, it will complain about the secret passphrase not being set in the configuration file.

  • Open \etc\apps\phpMyAdmin\config.inc.php and look for following code (around line 16) :
  • $cfg['blowfish_secret'] = 'mwerhgd-myhVgnvcVEjj'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
  • Replace the secret with a random string that is at least 32 characters long :
  • $cfg['blowfish_secret'] = 'P5DS+radU0TOqI7HX$cH!eb3zwnDDoDr'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
  • Save the file and exit de editor.
  • Log off and log back on again to phpMyAdmin. The warning should be gone now.

In case you installed phpMyAdmin for the first time, it may also complain about the phpMyAdmin configuration storage not being completely configured.

  • Inside the warning, click on the link Find out why.
  • Inside de next notice, click on the link Create.
  • phpMyAdmin will then create and configure the database named phpmyadmin.
  • Click on the Home button. The warning should be gone now.

3 Comments

  1. This was very helpful. Of all the content I came across on this topic, yours was the only one that mentioned the issue of cookie and editing that config file. That actually solved my problem.

    Thanks

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.