Ajout de serveurs

Adding via the web interface

1. Go to Servers > Add a server
2. Enter: host (IP or hostname), port (3306 by default), username and password
3. Select the client and environment (production, staging, dev...)
4. PmaControl tests the connection, detects the version and server type
5. Metric collection starts automatically

Server types

• Standard server — MariaDB / MySQL standalone or replica
• ProxySQL — SQL proxy with admin port (6032) and client port (6033)
• MaxScale — MariaDB routing proxy
• VIP — Virtual IP/DNS pointing to a real server
• SSH Tunnel — Connection via tunnel for servers not directly accessible

Server configuration

For each server, you can configure:

• SSL — Encrypted connection (CA certificates, client cert, client key)
• SSH — SSH key for hardware collection (disk space, CPU, RAM)
• Tags — Colored tags to organize your servers
• DNS Alias — PmaControl automatically detects aliases via reverse DNS resolution and SSH hostname
• Acknowledge — Alert acknowledgment for planned maintenance
• is_monitored — Enable/disable monitoring without deleting the server

Required MySQL permissions

The monitoring user needs the following privileges:

CREATE USER 'pmacontrol'@'%' IDENTIFIED BY 'mot_de_passe';
GRANT SELECT, PROCESS, REPLICATION CLIENT, SHOW DATABASES ON *.* TO 'pmacontrol'@'%';
GRANT SELECT ON performance_schema.* TO 'pmacontrol'@'%';
FLUSH PRIVILEGES;