3 Replies - 225 Views - Last Post: 24 May 2019 - 12:44 PM

#1 sayhello   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 214
  • Joined: 12-November 17

creation of a mysql-db with user, ... permission - which steps to take

Posted 23 May 2019 - 12:23 PM

good day dear experts hello dear dreamincode -frineds,


well - i mused bout the right place to post this question: Finally i decide to put it into this forum - software:... probably it fits most here. Please lemme know if i can put it better next time!!


i am running webmin


now for the creation of a mysql-db with user, user permission and so on..
which are the right steps and whhich is the correct sequence -


in other words: what comes first - second - third ...


btw: some of the net-ressources say like so;:
https://www.trustfm.....php?page=MySQL


first: Now go to Servers > MySQL Database Server.
Click the "Start" button in order to start the database server.
Now click the link "Create a new database".


next ...: create a new "User"


third:...After the user creation Webmin will lead you at the "User Permissions" page where you should have the newly created user userwebsite1db1 like the picture below.


forth: .. click at the "Return to database list" list located at the bottom of the page.


Finally we have to assign the userwebsite1db1 user at our website1db1 database.
Click at the "Database Permissions" icon. Hit the link "Create New Database Permissions."
>
> Now fill the "Create Database Permissions" form like this :
> Databases : selected website1db1
> Username : userwebsite1db1
> Host : localhost
> Permissions : ALL (use the CTRL key in order to enable multi-select)
>
> Hit the "Create" button.


and subsequently ... click at the "Return to database list" list located at the bottom of the page.
At this point we have finished with MySQL setup and configuration.


questions that arise:
- is it correct to use the db first or shouldnd i create a user at the first step!?
- what if i enter in the Create-DB-Section
~~~
Host: [] from Host Permission [] Any [] .... what if i choose here any instead of localhost
~~~


Question: can this be done!? Is it possible to choose here any and afterward in the credentials of the setup of - eg a wordpress site - i can choose localhost?




love to hear from you

Is This A Good Question/Topic? 0
  • +

Replies To: creation of a mysql-db with user, ... permission - which steps to take

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15106
  • View blog
  • Posts: 60,409
  • Joined: 12-June 08

Re: creation of a mysql-db with user, ... permission - which steps to take

Posted 23 May 2019 - 12:43 PM

There is a database section. Moving.
Was This Post Helpful? 0
  • +
  • -

#3 sayhello   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 214
  • Joined: 12-November 17

Re: creation of a mysql-db with user, ... permission - which steps to take

Posted 24 May 2019 - 12:43 PM

hello dear all and hello dear Modi 123


well i ve found out more infos -



i have seen a how-to: that guides through the process of setting up the db and the user:


Create and Manage MySQL Users in Webmin
https://admin-ahead....sers-in-webmin/

Quote

Create and Manage MySQL Users in Webmin
https://admin-ahead....sers-in-webmin/


To begin managing MySQL in webmin, do the following:

1) Login to webmin and find the section called “Servers”
2) Click “MySQL Database Server”
3) Select “User Permissions”

To create a new user:


1) Click “Create new user” under the table listing current users
2) Enter a user name and password
3) Select permissions (these are global privileges – you can set privileges for individual databases in another section
4) Click “Create”

To change permissions for specific databases, follow these steps:


1) From the MySQL Database Server page, click “Database Permissions”
2) Click the name of the database you want to manage
3) For “Username” toggle the box to the right of the anonymous box and enter the user you want to have permissions for this database
4) Select the permissions you want to grant. To select multiple permissions, hold the Control key and click them
5) Click “Save”.


well now i try to find out why it does not work with the installation of a wordpress-site..
note#: the wqeustion is: should i use

a. localhost or
b. any host

love to hear from you
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15106
  • View blog
  • Posts: 60,409
  • Joined: 12-June 08

Re: creation of a mysql-db with user, ... permission - which steps to take

Posted 24 May 2019 - 12:44 PM

I honestly do not understand what you wrote.

Maybe someone else will.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1