{% extends "base.html" %}{% block title %}Database Manager{% endblock %}{% block body %}
<div class="head"><div><small>DATA SERVICES · MARIADB / MYSQL</small><h1>Database Manager</h1><p>Create, rename, delete databases, manage users and safely grant/revoke privileges.</p></div><div class="action-row"><form method="post" action="/admin/databases/sync"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><button class="ghost">↻ Sync inventory</button></form>{% if phpmyadmin_installed %}<a class="btn" href="/admin/databases/phpmyadmin" target="_blank" rel="noopener">Open phpMyAdmin ↗</a>{% else %}<a class="soft" href="/admin/store">Install phpMyAdmin</a>{% endif %}</div></div>
<section class="stats"><div class="card stat"><small>DATABASES</small><strong>{{databases|length}}</strong><span>Non-system databases</span></div><div class="card stat"><small>DB USERS</small><strong>{{users|length}}</strong><span>MariaDB / MySQL accounts</span></div><div class="card stat"><small>HOST</small><strong>{{server.host}}</strong><span>Server endpoint</span></div><div class="card stat"><small>PORT</small><strong>{{server.port}}</strong><span>{{server.version or server.engine}}</span></div></section>
<div class="grid2">
<section class="card"><div class="cardhead"><div><small class="muted">CREATE DATABASE</small><h2>New database</h2></div></div><form class="formgrid" method="post" action="/admin/databases/create"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><label>Database name<input name="name" placeholder="customer_app" required></label><label>Hosting account<select name="account_id"><option value="">No account / system DB</option>{% for a in accounts %}<option value="{{a.id}}">{{a.username}}{% if a.domain %} · {{a.domain}}{% endif %}</option>{% endfor %}</select></label><div class="action-row" style="grid-column:1/-1"><button class="btn">Create database</button></div></form></section>
<section class="card"><div class="cardhead"><div><small class="muted">DATABASE USER</small><h2>Create / update user</h2></div></div><form class="formgrid" method="post" action="/admin/databases/users/create"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><label>Username<input name="user" placeholder="app_user" required></label><label>Host<input name="host" value="localhost" required></label><label>Password<input name="password" type="password" minlength="10" placeholder="10+ characters" required></label><div class="action-row" style="grid-column:1/-1"><button class="btn">Save user</button></div></form></section>
</div>
<section class="card"><div class="cardhead"><div><small class="muted">DATABASE INVENTORY</small><h2>Databases</h2></div></div><div class="tablewrap"><table><thead><tr><th>DATABASE</th><th>ACCOUNT</th><th>SIZE</th><th>HOST</th><th>PORT</th><th>STATUS</th><th>ACTIONS</th></tr></thead><tbody>{% for d in databases %}<tr><td><b>{{d.name}}</b><div class="muted" style="font-size:10px">{{d.provider}}</div></td><td>{% for a in accounts if a.id==d.account_id %}{{a.username}}{% else %}<span class="muted">Unassigned</span>{% endfor %}</td><td>{{d.size_human}}</td><td>{{d.host}}</td><td>{{d.port}}</td><td>{% if d.exists %}<span class="task-status completed">ONLINE</span>{% else %}<span class="task-status failed">MISSING</span>{% endif %}</td><td><div class="action-row"><form method="post" action="/admin/databases/{{d.id}}/rename"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><input class="inline-input" name="new_name" placeholder="new name" required><button class="soft">Rename</button></form><form method="post" action="/admin/databases/{{d.id}}/delete" onsubmit="return confirm('Delete database {{d.name}} and all data?')"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><button class="danger">Delete</button></form></div></td></tr>{% else %}<tr><td colspan="7" class="empty">No databases discovered. Install MariaDB/MySQL from App Store first.</td></tr>{% endfor %}</tbody></table></div></section>
<section class="card"><div class="cardhead"><div><small class="muted">ACCESS CONTROL</small><h2>Users & privileges</h2></div></div><div class="tablewrap"><table><thead><tr><th>USER</th><th>HOST</th><th>DATABASE</th><th>PRIVILEGES</th><th>SAFE ACTIONS</th></tr></thead><tbody>{% for u in users %}{% for d in databases %}<tr><td><b>{{u.user}}</b></td><td>{{u.host}}</td><td><code>{{d.name}}</code></td><td><form method="post" action="/admin/databases/privileges" class="priv-form"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><input type="hidden" name="user" value="{{u.user}}"><input type="hidden" name="host" value="{{u.host}}"><input type="hidden" name="database" value="{{d.name}}"><div class="priv-grid">{% for p in privileges %}<label><input type="checkbox" name="privilege" value="{{p}}">{{p}}</label>{% endfor %}</div><div class="action-row"><button class="btn" name="action" value="grant">Grant selected</button><button class="ghost" name="action" value="revoke">Revoke selected</button><button class="soft" name="action" value="revoke" onclick="this.form.querySelectorAll('input[type=checkbox]').forEach(x=>x.checked=false)">Revoke all</button></div></form></td><td><form method="post" action="/admin/databases/users/password" class="inline-form"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><input type="hidden" name="user" value="{{u.user}}"><input type="hidden" name="host" value="{{u.host}}"><input name="password" type="password" minlength="10" placeholder="new password" required><button class="soft">Change password</button></form><form method="post" action="/admin/databases/users/delete" onsubmit="return confirm('Delete database user {{u.user}}@{{u.host}}?')"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><input type="hidden" name="user" value="{{u.user}}"><input type="hidden" name="host" value="{{u.host}}"><button class="danger">Delete user</button></form></td></tr>{% endfor %}{% else %}<tr><td colspan="5" class="empty">No database users discovered.</td></tr>{% endfor %}</tbody></table></div><p class="muted" style="margin-bottom:0">Privileges are limited to the selected database. System schemas are never exposed by the manager.</p></section>
{% endblock %}