+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Adding MySQL users through the system (/thread-1583.html)
Adding MySQL users through the system - airhead - 10-22-2007 01:45 AM
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.