Control Web Panel

WebPanel => MySQL => Topic started by: venty on December 30, 2019, 07:26:19 AM

Title: has changed the procedure for creating databases and user in the user panel....
Post by: venty on December 30, 2019, 07:26:19 AM
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
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: Igor S. on December 30, 2019, 12:02:10 PM
What do you mean was changed? As I see all look good for understand.
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: venty on December 30, 2019, 10:52:22 PM
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


Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: venty on December 31, 2019, 10:58:49 AM
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
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: venty on January 01, 2020, 12:37:29 PM
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
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: venty on January 03, 2020, 10:24:27 AM
Pls, help...
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: venty on January 04, 2020, 02:19:35 PM
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
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: venty on January 05, 2020, 01:12:40 PM
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...
Title: Re: has changed the procedure for creating databases and user in the user panel....
Post by: kerim92 on February 04, 2020, 02:33:39 PM
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.