phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
- Supported versions
- Patch versions
- Getting information
- Additional Reading
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: my-service: type: phpmyadmin:4.7 hosts:  config: config: SEE BELOW overrides: environment: SEE BELOW
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 MySQLy 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.
Here is an example of a Landofile's
services config that connects to two
mysql database backends called
services: my-service: type: phpmyadmin hosts: - mysql57 - mysql8 mysql57: type: mysql:5.7 mysql8: type: mysql:8
You can override the default
phpmyadmin config by setting a custom phpMyAdmin config file as below.
A hypothetical project
Note that you can put your configuration files anywhere inside your application directory. We use a
config directory in the below example but you can call it whatever you want such as
./ |-- config |-- config.user.inc.php |-- .lando.yml
Landofile's phpmyadmin config
services: my-service: type: phpmyadmin config: config: config/config.user.inc.php
There are also serveral various envvars 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 like so:
my-service: 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
If you are interested in a working example of this service that we test on every Lando build then check out https://github.com/lando/lando/tree/master/examples/pma
- Updating your Landofiles to 3.0.0-rc.2+
- Accessing Your Services Externally
- Accessing Lando from Other Devices
- Exporting Databases
- Importing Databases
- Killer D8 Workflow with Platform.sh
- Lando + PhpStorm + Xdebug
- Offline Development
- Using $LANDO_INFO
- Using NodeJS Frontend Tooling
- Using Lando in Visual Studio Code
- Climbing a mountain for love
- SSH Keys
- Shared Files
- Global Config
- DNS Rebinding Protection
- File Uploads on Windows
- File Syncing Stalled
- Running VB and HyperV
- Running behind a proxy
- Switching Database Config