Author Topic: Why do I have 6 users for each DB?  (Read 8533 times)

0 Members and 2 Guests are viewing this topic.

Offline
**
Why do I have 6 users for each DB?
« 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?
« Last Edit: September 23, 2019, 12:44:29 PM by ring_c »

Offline
***
Re: Why do I have 6 users for each DB?
« Reply #1 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.

Re: Why do I have 6 users for each DB?
« Reply #2 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.

Offline
**
Re: Why do I have 6 users for each DB?
« Reply #3 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?

Re: Why do I have 6 users for each DB?
« Reply #4 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.