my first problem is user web16_u1 can see database web163db1 and web164db1 web165db1 , web166db1 ... and web169db1 with phpmyadmin. i have after see this login with root to phpmyadmin and serch the rights first i see all webs some webs have globala rights CREATE USER and the other haves the rights USAGE is this normaly ? . my Phpmyadmin version is 2.11.2.1 and mysql database is 5.0.51a-0
Thats a known bug in mysql. It seems that mysql will not fix this bug, so we switched to database names without underscore. But this workaround will not work for existing databases of course.
ok, what can I do. I do remove database and create new and play the sql tables in the new database. Gives the bug only in the number 16 and 160 or in the next number 17 and 170 have i the same problem ?
The bug is caused by the undercore, the underscore works similar like a wildcard. This should work, I'am not aware of another solution.
If I remember correctly, the problem is in the username with underscores and not the database name. So the ispconfig database name is not affected.
ok, i must change username, whats up with ispconfig when i do this from hand over phpmyadmin. looks than in ispconfig the database like this Database: web16_db1 username: web16u1
