Why do I have 6 users for each DB?

Started by ring_c, September 23, 2019, 12:41:28 PM

Previous topic - Next topic

ring_c

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:

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?

Jamshed Datori

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.

ejsolutions

Generally, localhost is all you need, unless you specifically want to allow remote access (pay attention to security). Delete the superfluous ones.

ring_c

Quote from: jamshed_206 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.
Did you get a reply?

cinique


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