{% extends "base.html" %}{% block title %}Databases{% endblock %}{% block body %}
<div class="head"><div><small>ACCOUNT DATA · MARIADB / MYSQL</small><h1>Databases</h1><p>Manage your databases, database users and database-level privileges.</p></div>{% if phpmyadmin_installed %}<a class="btn" href="/user/databases/phpmyadmin" target="_blank" rel="noopener">Open phpMyAdmin ↗</a>{% endif %}</div>
<section class="stats"><div class="card stat"><small>YOUR DATABASES</small><strong>{{databases|length}}</strong><span>Account-scoped</span></div><div class="card stat"><small>USERS</small><strong>{{users|length}}</strong><span>Account database users</span></div><div class="card stat"><small>HOST</small><strong>{{server.host}}</strong><span>Database 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</small><h2>New database</h2></div></div><form class="formgrid" method="post" action="/user/databases/create"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><label>Database name<input name="name" placeholder="app" required><span class="muted">Your account prefix is added automatically.</span></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">CREATE USER</small><h2>Database user</h2></div></div><form class="formgrid" method="post" action="/user/databases/users/create"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><label>Username<input name="user" placeholder="app_user" required><span class="muted">Your account prefix is added automatically.</span></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">Create user</button></div></form></section></div>
<section class="card"><div class="cardhead"><div><small class="muted">DATABASE INVENTORY</small><h2>Your databases</h2></div></div><div class="tablewrap"><table><thead><tr><th>DATABASE</th><th>SIZE</th><th>HOST</th><th>PORT</th><th>ACTIONS</th></tr></thead><tbody>{% for d in databases %}<tr><td><b>{{d.name}}</b></td><td>{{d.size_human}}</td><td>{{d.host}}</td><td>{{d.port}}</td><td><div class="action-row"><form method="post" action="/user/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="/user/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="5" class="empty">No databases yet.</td></tr>{% endfor %}</tbody></table></div></section>
<section class="card"><div class="cardhead"><div><small class="muted">ACCESS CONTROL</small><h2>Your database users</h2></div></div><div class="tablewrap"><table><thead><tr><th>USER</th><th>HOST</th><th>DATABASE</th><th>PRIVILEGES</th><th>PASSWORD</th></tr></thead><tbody>{% for u in users %}{% for d in databases %}<tr><td><b>{{u.user}}</b></td><td>localhost</td><td><code>{{d.name}}</code></td><td><form method="post" action="/user/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="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</button><button class="ghost" name="action" value="revoke">Revoke</button></div></form></td><td><form method="post" action="/user/databases/users/password" class="inline-form"><input type="hidden" name="csrf_token" value="{{csrf_token}}"><input type="hidden" name="user" value="{{u.user}}"><input name="password" type="password" minlength="10" placeholder="new password" required><button class="soft">Change</button></form></td></tr>{% endfor %}{% else %}<tr><td colspan="5" class="empty">Create a database user to manage access.</td></tr>{% endfor %}</tbody></table></div></section>
{% endblock %}