Opening a phpMyAdmin browser view of a local server I was unable to see any databases except the phpMyAdmin one.
How do I view MySQL databases which have been created using MySQL with phpMyAdmin?
On this server there were a number of databases, including one for WordPress.
The expectation is that the phpMyAdmin user doesn’t have the correct privileges assigned.
To make the change login to the MySQL database and use the grant privileges command.
Login to MySQL
mysql -u root -p
Grant access to the phpMyAdmin user.
grant all privileges on DATABASE_NAME.* to phpmyadmin@localhost identified by 'PASSWORD'; flush privileges;
Now refresh the phpMyAdmin screen to observe the addition of the missing databases.
Changing the privileges for the phpMyAdmin user within MySQL enabled the listing of all of the databases.
