Creating and managing databases
Steps:
- Log in at www.lbreeze.net.
- Go to Databases → Add database.
- Enter a database name, create a user, and assign a strong password.
- Set user permissions (read/write/admin).
- Save. Note host (usually localhost), database name, username, and password for application config.
Best practices:
- Use one database per application to isolate data.
- Avoid using the same user across multiple databases.
- Rotate credentials when staff changes; remove unused users.
Troubleshooting:
- If connection fails, confirm host, port, credentials, and permissions.
- Check application config files and environment variables for typos.