How to set up and use phpMyAdmin with Laravel Valet

Assume we already have Valet and MySQL on our machine. What if we want to access our databases through a graphical user interface like phpMyAdmin without running a whole platform like XAMPP or MAMP?

Install PhpMyAdmin

brew install phpmyadmin

Go to phpMyAdmin’s directory and link as a Valet site

cd /usr/local/share/phpmyadmin
valet link pma

In the snippet above, I linked the directory as pma, make sure Valet is started, then we can access the site at pma.vl (my Valet domain is set to vl).

Configure phpMyAdmin

By default phpMyAdmin does not allow login with a blank password, therefore we cannot login with MySQL default root user. To disable this, open the file config.inc.php and find the line that has AllowNoPassword, uncomment and set it to true.

$cfg['Servers'][$i]['AllowNoPassword'] = true;

Login again and enjoy!

References