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?
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).
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
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Login again and enjoy!
- Setup phpMyAdmin with Laravel Valet
- Error: Login without a password is forbidden by configuration (see AllowNoPassword)