cwp-databaselisted

# CWP Database Management Manage MySQL/MariaDB, PostgreSQL, and MongoDB databases on CWP servers. Handle database creation, user management, performance tuning, upgrades, and recovery. ## Database Services Overview | Database | Default | Management Tool | |---|---|---| | MariaDB | Installed by default | phpMyAdmin included | | MySQL | Alternative to MariaDB | phpMyAdmin included | | PostgreSQL | Optional install | phpPgAdmin | | MongoDB | Optional install | MongoDB Manager | ## Service Detection Detect which database services are installed: ```bash # MariaDB (installed by default) systemctl is-active mariadb 2>/dev/null && echo "MariaDB: active" || echo "MariaDB: not running" # PostgreSQL (optional) systemctl is-active postgresql 2>/dev/null && echo "PostgreSQL: active" || echo "PostgreSQL: not installed" # MongoDB (optional) systemctl is-active mongod 2>/dev/null && echo "MongoDB: active" || echo "MongoDB: not installed" ``` ## MariaDB/MySQL ### Configuration Files | File | Purpose | |---|---| | `/etc/my.cnf.d/server.cnf` | MariaDB main configuration | | `/root/.my.cnf` | MySQL root credentials | | `/etc/yum.repos.d/mariadb.repo` | MariaDB repository | | `/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php` | CWP database connection | ### Access phpMyAdmin - URL: `https://SERVER_IP:2030/phpMyAdmin/` - Credentials: Use root password from `/root/.my.cnf` ### Common Database Operations ```bash # Access MySQL CLI mysql -u root -p # Access with stored cre