MySQL

​

Overview

• Self-hosted MySQL
• Amazon RDS for MySQL
• Azure Database for MySQL
• Google Cloud SQL for MySQL
• PlanetScale
• MariaDB

​

Connection Details

​

Setting Up a Read-Only User

-- Create user
CREATE USER 'plumi_readonly'@'%' IDENTIFIED BY 'your_secure_password';

-- Grant select permission on all tables
GRANT SELECT ON your_database.* TO 'plumi_readonly'@'%';

-- Apply changes
FLUSH PRIVILEGES;

​

Cloud Provider Setup

​

Amazon RDS

1. Ensure your RDS instance allows remote connections
2. Add Plumi’s IP to your security group
3. Use the RDS endpoint as the host

​

Azure Database

1. Add firewall rules for Plumi’s IP
2. Use the server name as host (e.g., yourserver.mysql.database.azure.com)
3. Username format: username@servername

​

PlanetScale

1. Create a new branch or use your main branch
2. Generate connection credentials from the dashboard
3. Use the provided host, username, and password

​

Troubleshooting

​

”Host is not allowed to connect”

UPDATE mysql.user SET Host='%' WHERE User='plumi_readonly';
FLUSH PRIVILEGES;

​

“Access denied”