database

[planet_fox]

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

[till]

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.

[planet_fox]

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 ?

[till]

The bug is caused by the undercore, the underscore works similar like a wildcard.

I do remove database and create new and play the sql tables
in the new database.

This should work, I'am not aware of another solution.

[planet_fox]

all databse with underscore have the bug ? thats so bad .

[planet_fox]

oh I see i have underscure in the isp database, there must change as first

[till]

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.

[planet_fox]

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

[till]

No, ISPConfig is not able to recognize changes that you made in phpmyadmin.