mysql user names and databse names problem

[blocker]

Hello,

i have the following problem:

i have a web page - web57 with databases web57_db1 with user web57_u1 and web57_db2 with user web57_u2.

the problem is when i login to phpmyadmin with user web57_u1, i see all the databases web57*_db1 - for example web577_db1, web578_db1 e.t.c.

and

when i login to phpmyadmin with user web57_u2 i see all the databases web57*_db2 - for example web577_db2, web578_db2 e.t.c.

what could be the reason for that, and how can i fix that without changing database names and database users...

Thanks!

[till]

Thats a known bug in mysql and related to the underscore in the usernames which is misinerpreted by mysql as wildcard. All current ispconfig versions use a new naming scheme to prevent this for newly created databases.

[blocker]

Originally Posted by till

Thats a known bug in mysql and related to the underscore in the usernames which is misinerpreted by mysql as wildcard. All current ispconfig versions use a new naming scheme to prevent this for newly created databases.

Thanks for the reply

i would like to ask if there is another solution to go over the problem except renaming the databases and the user names?

Thanks!

[till]

There is no other solution as far as I know. But maybe you find something with google, the problem with underscores in mysql usernames is not ispconfig specific.

[blocker]

i just asked, it became clear that it is not ispconfig related just after your 1st post

thanks a lot