can’t access db

  • move site to new server backed up db and restored to new server, in phpmyadmin all is there and looks good. When I try to connect from site get the world press page saying can’t connect to db because of user name, password or db name.
    I took the wp_config and changed the old to the new and did not alter the password the changes I made are shown to the right of the // and yes I did actually make the change to adventur_areas this was the old working info

    define(‘DB_NAME’, ‘dothanby_wrdp11’); // adventur_wrdp11
    define(‘DB_USER’, ‘dothanby_wrdp11’); // adventur_randy
    define(‘DB_PASSWORD’, ‘XXXXXXXXX[‘); // made no changes
    define(‘DB_HOST’, ‘localhost’);

Viewing 1 replies (of 1 total)

  • If you’re sure that the username and password are right, check the database name. On one of the websites I maintain, I can’t choose the name of the DB, so if you’ve moved hosts, the new host might have created a database with a different name.

    Also, the DB_HOST might need to change.

    localhost means that the mysql server (i.e. the program that reads/writes to the database) is on the same computer as the web server (i.e. the program that actually sends the pages to people).

    That’s not always the case with some hosts: some will put the mysql server on a different computer, and in that case you need to change localhost to whatever address they give you.

    You should also bear in mind that different hosts have different settings with their mysql installations. For example, there are a number of different database engines out there, like MyISAM or InnoDB — these are basically two different ways of organising the database files. If you’ve been using a host that uses MyISAM and you move to an InnoDB host, your backup file will need to be modified slightly to make it compatible.

    That’s just something to think about once you’ve got the login details right, though ??

Viewing 1 replies (of 1 total)
  • The topic ‘can’t access db’ is closed to new replies.