| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Open Suse |
| Webmin version | version 2.402 |
good day dear friends,
i manage my wordpresss istes on a root server - which is adminstered by my friend the installed webmin is the Webmin version 2.402
here i create for the vhosts - a db the user and all the permissions that are necessary.
what about the idea to create all the steps through the sql-statement-widget. in webmin we have such a widget - can i use that?
The SQL-Statements: note i am not able to use a cli - my admin did not set up such.. so i do not have the Global-SQL-Interface.
but i tested it i applied (at least some first) SQL Statements which i runned in the so called per-DB-Execution Widget.
the awesome Thing: IT works - can apply the SQL-Statement and it works
a. generates Databases
b. generates Users
etc. etx.
conclusio; i love the way using SQL-Statements and paste it directly into Webmin’s SQL widget and avoid messing up the order.
generally spoken there are some differences - in the NON-GUI way and method: the Question is : “Where to Execute SQL Globally in Webmin”?
hmm - one pathway:
i go to Servers > MySQL Database Server.
Scroll down to Global Options
Click Database Connections → inside there you should see an option for Execute SQL on server (instead of on a single database).
note: the differences some musings:
that’s the place where we can run the full SQL sequence (database + user + grants). But note i only see the “per-database SQL Editor”, i guess then i can still run CREATE DATABASE and CREATE USER there
Note: MySQL doesn’t care which DB we’re “in” when running those commands, because they’re server-wide statements. 
so - i am gonna try this out Tonight: (when i am at home at the machine: )
with this SQL Template: i Guess this is a clean, reusable SQL snippet i can run in the Webmin SQL editor (global or per-database, both will work):
-- STEP 1: Create the database
CREATE DATABASE IF NOT EXISTS `__DBNAME__`
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;
-- STEP 2: Create the user (replace password!)
CREATE USER IF NOT EXISTS `__DBUSER__`@'localhost'
IDENTIFIED BY '__PASSWORD__';
-- STEP 3: Grant permissions for WordPress
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
ON `__DBNAME__`.*
TO `__DBUSER__`@'localhost';
-- STEP 4: Apply changes
FLUSH PRIVILEGES;
How i will Use It - i will do the following
Replace DBNAME with my new database name (e.g. wp_forum).
Replace DBUSER with my new user name (e.g. wp_forum_user).
Replace PASSWORD with a strong password.
the question is: can you confirm that it is possible to run all the neceary commands through the so called “per-DB” - widget!? And that there is no General DB-Widget necesary!?
Look forwawrd to hear from you
greetings 
update: i ve added two views - of the SQL-Execution options… seee below the … view on the general SQL-Execution widget -( which is not installed (or activated) on my site here:
SQL Toolbox – Quick Reference (Webmin + WordPress)
Deutsch + 
English
With this cheat sheet you can set up and manage WordPress databases in Webmin without depending on a buggy GUI.