Control Web Panel

WebPanel => MySQL => Topic started by: ring_c on September 23, 2019, 12:41:28 PM

Title: Why do I have 6 users for each DB?
Post by: ring_c on September 23, 2019, 12:41:28 PM
Hi,


I've just noticed that I have a few DBs with 6 users. I believe the common thing between them all is that they were imported from a different hosting company.
So I have something like that:

Code: [Select]
db_name [O] [C] [R] [B]      db_user1 [xx.xx.xx.xx] [P]
                                          db_user1 [localhost] [P]
                                          db_user1 [old.hosting.com] [P]
                                          db_user2 [xx.xx.xx.xx] [P]
                                          db_user2 [localhost] [P]
                                          db_user2 [old.hosting.com] [P]

Any idea if this is normal? Should I remove the users which are not localhost?
Title: Re: Why do I have 6 users for each DB?
Post by: Jamshed Datori on February 09, 2020, 01:56:38 PM
Yes. You can use the users other than [localhost] since others are not needed.

This happens when you import cPanel account to CWP. I have sent the ticket to CWP support for the same issue and hoping a response from them.
Title: Re: Why do I have 6 users for each DB?
Post by: ejsolutions on February 09, 2020, 03:19:28 PM
Generally, localhost is all you need, unless you specifically want to allow remote access (pay attention to security). Delete the superfluous ones.
Title: Re: Why do I have 6 users for each DB?
Post by: ring_c on September 10, 2020, 06:53:09 AM
Yes. You can use the users other than [localhost] since others are not needed.

This happens when you import cPanel account to CWP. I have sent the ticket to CWP support for the same issue and hoping a response from them.
Did you get a reply?
Title: Re: Why do I have 6 users for each DB?
Post by: cinique on September 10, 2020, 08:46:21 AM

Did you get a reply?
[/quote]
Non-issue: re-read replies.
Remote SQL access had previously been granted.