Setup MySQL

MySQL este o componenta centrala cand vrei datele panelului + baze gestionate per-server. Acest ghid foloseste MySQL in Docker pe portul 5757.

1. Setup automat (recomandat)

Ruleaza scriptul automat; el creeaza containerul si iti cere credentiale (root, user panel, user host).

cd /home/mihai/Desktop/cpanel
chmod +x auto-db.sh
./auto-db.sh

Scriptul afiseaza valorile exacte pentru .env si credentialele pentru Admin > Databases.

2. Configureaza panelul pe MySQL (5757)

cd /home/mihai/Desktop/cpanel/panel
cp .env.mysql-docker.example .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=5757
DB_DATABASE=panel
DB_USERNAME=cpanel
DB_PASSWORD=change_me_panel_password

npm run upgrade-db
npm run create-user
npm run dev

3. Adauga DB host in admin panel

Mergi la /admin/databases
Adauga host de tip mysql, host/IP, port 5757, user cpanelhost si parola
Foloseste actiunea de ping/validare inainte sa creezi baze per-server

Setup manual (optional)

Foloseste asta doar daca vrei sa rulezi MySQL fara script.

Porneste MySQL in Docker

cd /home/mihai/Desktop/cpanel/panel
docker compose -f docker-compose.mysql.yml up -d
docker compose -f docker-compose.mysql.yml ps

Logare in MySQL shell

Foloseste credentialele root din docker-compose.mysql.yml (sau valorile tale override din env).

docker exec -it cpanel-mysql mysql --protocol=tcp -h 127.0.0.1 -P 5757 -u root -p

Creare manuala baze/useri

CREATE USER 'cpanel'@'%' IDENTIFIED BY 'change_me_panel_password';
CREATE DATABASE panel;
GRANT ALL PRIVILEGES ON panel.* TO 'cpanel'@'%';
FLUSH PRIVILEGES;

CREATE USER 'cpanelhost'@'%' IDENTIFIED BY 'change_me_host_password';
GRANT ALL PRIVILEGES ON *.* TO 'cpanelhost'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;