database

Discussion in 'General' started by planet_fox, Jun 16, 2008.

  1. planet_fox

    planet_fox Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. planet_fox

    planet_fox Member

    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 ?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

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

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

    planet_fox Member

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

    planet_fox Member

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

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  8. planet_fox

    planet_fox Member

    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
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

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

Share This Page