Adding MySQL users through the system
|
Author |
Message |
airhead
Posts: 1
Joined: Oct 2007
Reputation: 0
|
Adding MySQL users through the system
Hi,
I have a little questions about adding mysql users via the ispcp.
When I add the user it inserts it in table sql_users in the ispcp database.
There are 2 problems.
The first is that I can add several users with the same username, because the PK is on an auto_increment column (sqlu_id).
The second problem is that the users cannot be used, because they are added only in this table. Even on "Exeute SQL" from the ispcp it tries to login to the MySQL using the user and pass from this table but there are no records for this user in mysql.user
Can you please tell me how this whole mechanism is working?
Thanks in advance.
|
|
10-22-2007 01:45 AM |
|
Messages In This Thread |
Adding MySQL users through the system - airhead - 10-22-2007 01:45 AM
|
User(s) browsing this thread: 1 Guest(s)