Current time: 11-27-2024, 02:20 PM Hello There, Guest! (LoginRegister)


Post Reply 
Adding MySQL users through the system
Author Message
airhead Offline


Posts: 1
Joined: Oct 2007
Reputation: 0
Post: #1
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
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)