Author Topic: has changed the procedure for creating databases and user in the user panel....  (Read 2589 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
Hi,

has changed the procedure for creating databases and user in the user panel, please give us instructions ...

1. Permissions for the user...??!? Resource limits... ?!?

2. How to create a database and user in the new procedure, but have the same rights as before ...?!?


BR
Venty
« Last Edit: December 30, 2019, 08:29:48 AM by venty »

Offline
*****
What do you mean was changed? As I see all look good for understand.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
***
Hi,

1. Before I went into the user panel and then I chose the SQL Services / SQL Manager I had two buttons "Add database + user" and another button "Add user" ..

2. I chose the first one "Add database + user" and created both the datаbase and the user for it ... and with that I created the requested base and the user ... I never used the second button ...

3. Now I have two buttons again, but the first one is just the "Аdd datаbase", the one I choose opens the following screen:

http://prntscr.com/qhp30e

4. Of course I try and choose the link 2 "Create user", but then additional options open to me ...

5. The red line is clear, but what to do with Permissions for the user ... ??!? and Resource limits ...?!?

http://prntscr.com/qhp5ah

Before in point 2 of that description "Add database + user" - the user I think was with All Privileges ???

I have some idea of databases and users, but in the cases there are no special requirements - I just want to create a database and a user for it, as it happened before in point 2 of this description ...?!?

Thanks in advance!

BR
Venty



Offline
***
Hi,

1. Before I went into the user panel and then I chose the SQL Services / SQL Manager I had two buttons "Add database + user" and another button "Add user" ..

2. I chose the first one "Add database + user" and created both the datаbase and the user for it ... and with that I created the requested base and the user ... I never used the second button ...

3. Now I have two buttons again, but the first one is just the "Аdd datаbase", the one I choose opens the following screen:

http://prntscr.com/qhp30e

4. Of course I try and choose the link 2 "Create user", but then additional options open to me ...

5. The red line is clear, but what to do with Permissions for the user ... ??!? and Resource limits ...?!?

http://prntscr.com/qhp5ah

Before in point 2 of that description "Add database + user" - the user I think was with All Privileges ???

I have some idea of databases and users, but in the cases there are no special requirements - I just want to create a database and a user for it, as it happened before in point 2 of this description ...?!?

Thanks in advance!

BR
Venty

Hi again,

in addition - I do not see any options for LOCK TABLES and REFERENCE in Permissions for the user... ?!?

Thanks in advance!

BR
Venty

Offline
***
Hi,

1. Before I went into the user panel and then I chose the SQL Services / SQL Manager I had two buttons "Add database + user" and another button "Add user" ..

2. I chose the first one "Add database + user" and created both the datаbase and the user for it ... and with that I created the requested base and the user ... I never used the second button ...

3. Now I have two buttons again, but the first one is just the "Аdd datаbase", the one I choose opens the following screen:

http://prntscr.com/qhp30e

4. Of course I try and choose the link 2 "Create user", but then additional options open to me ...

5. The red line is clear, but what to do with Permissions for the user ... ??!? and Resource limits ...?!?

http://prntscr.com/qhp5ah

Before in point 2 of that description "Add database + user" - the user I think was with All Privileges ???

I have some idea of databases and users, but in the cases there are no special requirements - I just want to create a database and a user for it, as it happened before in point 2 of this description ...?!?

Thanks in advance!

BR
Venty

Hi again,

in addition - I do not see any options for LOCK TABLES and REFERENCE in Permissions for the user... ?!?

Thanks in advance!

BR
Venty

Hi again,

in one more addition and developing the theme - I created different databases and users, with privileges, without privileges, partial rights, I created the user with the databases, create user with the databases attached it, detach it ...........- and all these test databases and users I tried to do one installation of prestashop - it always breaks when it comes to installing the databases ....?!?

Thanks in advance!

BR
Venty

Offline
***
Pls, help...

Offline
***
Hi,

1. Before I went into the user panel and then I chose the SQL Services / SQL Manager I had two buttons "Add database + user" and another button "Add user" ..

2. I chose the first one "Add database + user" and created both the datаbase and the user for it ... and with that I created the requested base and the user ... I never used the second button ...

3. Now I have two buttons again, but the first one is just the "Аdd datаbase", the one I choose opens the following screen:

http://prntscr.com/qhp30e

4. Of course I try and choose the link 2 "Create user", but then additional options open to me ...

5. The red line is clear, but what to do with Permissions for the user ... ??!? and Resource limits ...?!?

http://prntscr.com/qhp5ah

Before in point 2 of that description "Add database + user" - the user I think was with All Privileges ???

I have some idea of databases and users, but in the cases there are no special requirements - I just want to create a database and a user for it, as it happened before in point 2 of this description ...?!?

Thanks in advance!

BR
Venty

Hi again,

in addition - I do not see any options for LOCK TABLES and REFERENCE in Permissions for the user... ?!?

Thanks in advance!

BR
Venty

Hi again,

in one more addition and developing the theme - I created different databases and users, with privileges, without privileges, partial rights, I created the user with the databases, create user with the databases attached it, detach it ...........- and all these test databases and users I tried to do one installation of prestashop - it always breaks when it comes to installing the databases ....?!?

Thanks in advance!

BR
Venty

Hi again,,

As I wrote above - since the last update I have a problem with creating databases and users to them in the user panel ....

I found that when I create a database user and select all possible .... (see picture):

http://prntscr.com/qjabt0

..... after checking for real user privileges I see this - not all are received privileges, regardless of being selected (see picture):

http://prntscr.com/qjackv

Lastly, when creating a new user, I'm not sure, but the options shown on the screen aren't all that the user can actually get "All Privileges" for the user ...LOCK TABLES, REFERENCE....

thanks in advance!

BR
Venty

Offline
***
Hi,

1. Before I went into the user panel and then I chose the SQL Services / SQL Manager I had two buttons "Add database + user" and another button "Add user" ..

2. I chose the first one "Add database + user" and created both the datаbase and the user for it ... and with that I created the requested base and the user ... I never used the second button ...

3. Now I have two buttons again, but the first one is just the "Аdd datаbase", the one I choose opens the following screen:

http://prntscr.com/qhp30e

4. Of course I try and choose the link 2 "Create user", but then additional options open to me ...

5. The red line is clear, but what to do with Permissions for the user ... ??!? and Resource limits ...?!?

http://prntscr.com/qhp5ah

Before in point 2 of that description "Add database + user" - the user I think was with All Privileges ???

I have some idea of databases and users, but in the cases there are no special requirements - I just want to create a database and a user for it, as it happened before in point 2 of this description ...?!?

Thanks in advance!

BR
Venty

Hi again,

in addition - I do not see any options for LOCK TABLES and REFERENCE in Permissions for the user... ?!?

Thanks in advance!

BR
Venty

Hi again,

in one more addition and developing the theme - I created different databases and users, with privileges, without privileges, partial rights, I created the user with the databases, create user with the databases attached it, detach it ...........- and all these test databases and users I tried to do one installation of prestashop - it always breaks when it comes to installing the databases ....?!?

Thanks in advance!

BR
Venty

Hi again,,

As I wrote above - since the last update I have a problem with creating databases and users to them in the user panel ....

I found that when I create a database user and select all possible .... (see picture):

http://prntscr.com/qjabt0

..... after checking for real user privileges I see this - not all are received privileges, regardless of being selected (see picture):

http://prntscr.com/qjackv

Lastly, when creating a new user, I'm not sure, but the options shown on the screen aren't all that the user can actually get "All Privileges" for the user ...LOCK TABLES, REFERENCE....

thanks in advance!

BR
Venty

Pls, help...

Offline
*
yes i am facing same problem.
https://forum.centos-webpanel.com/index.php?topic=1786.msg28260#msg28260

by the way serverside possible to correct problem not for users. i think difference between cwp and whm something like this.