1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

database name with underscores

Discussion in 'Plesk for Linux - 8.x and Older' started by zacpac, Mar 1, 2005.

  1. zacpac

    zacpac Guest

    0
     
    Has anyone found a fix for the problem with database names with _'s in them as i just migrated a plesk 5 box and everything went really well until i found this problem !


    thanks

    dan
     
  2. defencer

    defencer Guest

    0
     
    What's problem?
     
  3. alex042

    alex042 Guest

    0
     
    Is this just a migration issue? We have some databases in 7.5 with _'s and have no problems with those.
     
  4. zacpac

    zacpac Guest

    0
     
    could it be a mysql 4 problem ??

    i create a database such as this_is_test and give it a username and a password and then i try and use plesk's phpmyadmin

    i get the following error

    1227 - Access denied. You need the SHOW DATABASES privilege for this operation

    i get this error on both a 7.5.1 box and a 7.5.2 box bothing using mysql 4.0.23a.ART
     
  5. zacpac

    zacpac Guest

    0
     
    just check have added 2 new databases one with _ in the name and one without i can use phpmyadmin on the one with out and i get the error above on the one with
     
  6. zacpac

    zacpac Guest

    0
     
    right i have worked out the problem just to implement the answer

    basically plesk stored the db name in the mysql.db tables with \_ in the name rather than the name and when the db name is being passed to phpmyadmin it doesnt have the \ in it and therefore it can not find the privilges to allow you to access it

    this is why it doesnt affect db names without _ in them
     
  7. zacpac

    zacpac Guest

    0
     
    hurrah now its fixed :)

    just add a nice line to the config.inc.php of the plesk version of phpmyadmin

    $db_name = str_replace("_","\_", $db_name);

    and all is now good in the world again
     
  8. alex042

    alex042 Guest

    0
     
    We had problems with mysql 4, in fact, in our migration from 7.1 to 7.5, we had problems with mysql 3 and 4 but after upgrading to 4 then back down to 3, we haven't had any other issues. So i'm not sure if this is a mysql version issue for you or not but it's possible.
     
  9. zacpac

    zacpac Guest

    0
     
    yeah i really want to keep mysql4 as some customers are using some of the functions from it already :-(

    i have opened a ticket with plesk and they seem to be looking into it wether anything happens is another thing but they seem keen to find the cause
     
Loading...