which steps to take while setting up a new db on Webmin
here the SYSTEM INFORMATION||
| OS Type | SuSE Linux 12.3 |
|---|---|
| Virtualmin Version | 1.973 of Webmin |
well which things have to be done first: should i first
a. create a user
b. create a db
c. create a user-permission
d. create a host permission
e. create a db-permission
well is there any concrete order - or a way to do the setup - mandantory!?
look forward to hear from you
Can be copied and pasted from the Dashboard icon
requested (because it helps everyone to contribute to answering questions here)
in Virtualmin -> Edit Databases just use logic
ie. how can you do anything with a db until you create it? (that page tabs will also show the db_user and db_pass) and allow you to manage the db with sql or the gui)
I am assuming the db requested is a MySQL (MariaDb) - I prefer to do everything with raw SQL commands but you could install phpMyAdmin a popular free Webapp to manage the database.
hi there - i will do have a closer look _ at the moment i am not in front of the machine where i can log in. to the webmin
i come back later the eveing and provide you with the info.
Thank you so much for all you do - i love webmin - but i eagerly need to know how to use the right order to setup
greetings
If you create a new virtual server all of this is done for you, are you trying to add a second to an existing virtual server ?
You could interchange virtual server with domain or are you just trying to create a new database and user to add a random database for some project
thank you for all the replies 
well i run the version 1.973 of webmin
and - hmm - i only have Webmin here running - the backend of the server is managed by my friend.
he creates the vhost and connnects the domain to a directory in the domain-root (on the server) . And i do the creation of the db - and the according userâŠ
these are the processes here.
i look forward to hear from you
regards dhubs
UPdate
Error establishing database connection This means either that the username and password information in your wp-config.php file is incorrect, or we cannot reach the database server on localhost. It could be that your hostingâs database server is down. Are you sure your username and password are correct? Are you sure you entered the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean, you should contact your web hosting providerâs support. If you still need help, you can always visit the WordPress support forums:
question - which methods do help here _ to check wether a db setup was successful
how to check this!
i need some methods that help me to check the setup of the db!?
look forward to hear from you
Well in that case there is no much anyone can help with using virtualmin automates the creation of the vhost which in turn automatically creates the database with the correct privs for the user. That said you are using such an old version of webmin it may be worth starting a fresh and installing virtualmin rather than just webmin which will reduce the work load
You should really upgrade to the latest Webmin 2.202, as version 1.973 is ancient and insecure!
They havenât mentioned that theyâre using Virtualmin. So, the simple answer may not work for them.
A point I made in my first reply (missing the answer to the âsystem infoâ it is a pity this is not a requirement in starting a topic along with the instruction on how to copy it, it is missed off far too often). OK I did edit the reply to add the additional info - I should have made that clearer I had assumed by then that the OP had full access and was on a Virtualmin system. and it was current (or at least recent)
It is complicated when dealing with a third party.
thank you so much joe - youre right : we do not use vitualmin here - or in other words : i only have the webmin dashboard here: so the question (at least for me remainsâ
what to to -wich order to run
a.
b.
c.
d or opposite!?
The order doesnât matter. You can create a user or a database first. Then permissions last.
Virtualmin handles all this automatically for domains managed by it (at least for the general case, you can still do fine-grained user permissions and stuff in the Webmin MySQL/Mariadb module).
good day dear joe, 
first of all: merry Xmas - merry Christmas to you all 
many thanks - for the reply. i will try to do as adviced:
hmm as mentioned above. i do not have the virtualmin here running - AT least i do not have access to it:
as i am eagerly trying to this db-setup - with all the necessary things i thought that i do this like so:;
When setting up a new database with Webmin, there is a sensible order that ensures that everything is configured correctly and no permissions are missing. The order is as follows:
Create database:
Start by creating the database, as all further steps are based on this. In Webmin, you can do this via the MySQL Database Server section.Create user:
Next, create a user who will later have access to the database. Enter a username and password.Assign user permissions:
Assign the user the appropriate permissions for the previously created database.Make sure the user is given permissions such as SELECT, INSERT, UPDATE, etc.
This is done in the database permissions section.
- Configure host permissions (if necessary)
If the user is not only supposed to access the server locally (e.g. from a remote host), you need to adjust the host permissions.For example, we can specify that the user only has access from a specific IP address.
hmm - dear Joe - this little manual - this does not fit - does not the job: so i will try to do the setup according to your ideas and tipps.
thank you so much for sharing your ideas, tipps and all!!!
i am happy for being part of this forum âŠ
greetings
g day
belive me or not - this issue allmost drives me nuts
btw: do you think that it may help if i use these options!?
do you think that i could succed if i create a user and a db with these steps here!?
Look forwar to hear from you
I have no idea what youâre trying to do or what problem youâve had thatâs driving you nuts.
Synchronizing UNIX and MySQL/Mariadn users is probably completely unrelated to the problem, though.
Trying to set up a WP site? I think you create a database and a user with the proper permissions. WP does the rest.
Change the database name ânew_wpâ to whatever you want.
Two places, create database & grant all privileges on
Change the username and password.
wpuser & myp@Ssw0Rd
Leave the â marks around password.
mysql
MariaDB [(none)]> create database new_wp;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> grant all privileges on new_wp.* to wpuser@localhost identified by 'myp@Ssw0Rd';
Query OK, 0 rows affected (0.01 sec)