phpMyAdmin (opens new window) is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
# Supported versions
# Legacy versions
# Patch versions
Here are the configuration options, set to the default values, for this service. If you are unsure about where this goes or what this means, we highly recommend scanning the services documentation to get a good handle on how the magicks work.
services: myservice: type: phpmyadmin:5.0 hosts:  config: config: SEE BELOW overrides: environment: SEE BELOW
# Connecting to database services
You will need to list the database services you want to be able to access via
phpmyadmin. Note that the services in this list should be other MySQL-y services in your application. They can be discovered by running lando info.
Note that PhpMyAdmin is designed specifically for MySQL and MariaDB type databases!
You will likely be sad if you try to use a non-MySQL-ish database.
An example of a Landofile's
services config that connects to two
mysql database backends called
mysql8 is shown below:
services: myservice: type: phpmyadmin hosts: - mysql57 - mysql8 mysql57: type: mysql:5.7 mysql8: type: mysql:8
# Using custom phpmyadmin config file
You can override the default
phpmyadmin config by setting a custom phpMyAdmin config file (opens new window) as shown below:
A hypothetical project
Note that you can put your configuration files anywhere inside your application directory. We use a
config directory but you can call it whatever you want such as
.lando in the example below:
./ |-- config |-- config.user.inc.php |-- .lando.yml
Landofile's phpmyadmin config
services: myservice: type: phpmyadmin config: config: config/config.user.inc.php
There are also several various envvars (opens new window) exposed by the underlying image we use that you can set to further customize how your PhpMyAdmin works. These are not officially supported so we highly recommend you do not alter them unless you know what you are doing. Even then, YMMV.
That said, you will need to use a service override to take advantage of them as shown below:
myservice: type: phpmyadmin hosts: - database overrides: environment: PMA_ARBITRARY: when set to 1 connection to the arbitrary server will be allowed PMA_HOST: define address/host name of the MySQL server PMA_VERBOSE: define verbose name of the MySQL server PMA_PORT: define port of the MySQL server PMA_HOSTS: define comma separated list of address/host names of the MySQL servers PMA_VERBOSES: define comma separated list of verbose names of the MySQL servers PMA_USER: define username to use for config authentication method PMA_PASSWORD: define password to use for config authentication method PMA_ABSOLUTE_URI: define user-facing URI