• hi!

    i want to upgrade wordpress from 2.8.6 to 3.0.3.

    a prequesite to this upgrade is to advance the mysql version from 4.0.x to 5.0.x.

    so i made a mysql dump from the mysql4 database. i created a new database on a mysql5 server and populated it with the data from the dump. after several tries i even figured out how to also import all special/foreigen characters correctly.
    then i edit wp-config.php to point to the new database.

    so far so good.

    wp is able to connect to the new db.

    but when i try to login i always and with all users and permissionlevels get a “You do not have sufficient permissions to access this page.”. in detail: i enter login and password, click “Log In” and on the next page (page profile.php) i get the above mentioned error message.

    i have done a lot of search regarding this topic. please note, that the table prefixes did NOT change while migrating the database. they are “wp_” in the old and in the new database.
    also the error occours right after login. not when trying to configure a plugin.

    i lost a notable count of hair and a notebale count of hair turned grey while i tried to solve this migration problem. posting here and maybe in some newsgroup is my last resort.

    any help AND an pointing into a direction or any guess is apprechiated.

    thanks and regards,
    art

  • The topic ‘Permission problem after database migration from mysql 4.0 to 5.0’ is closed to new replies.