• Can’t select database
    We WERE able to connect to the database server (which means your username and password is okay) but not able to select the “dman2840_wordpress” database.

    help. i need this problem resolved so I can change my database name

Viewing 7 replies - 1 through 7 (of 7 total)
  • I have built my website using netobjectsfusion and followed the instructions for publishing. Aklthough I’m getting a message that says the pages were uploaded I can not access the website

    I have finally found an answer to this problem. I recently purchased phpMyDirectory and so I asked my tech support Ben Johnson and he recommended that I change my hostname from localhost to my domain name and IT WORKED! I installed wordpress in less than 5 mintues. So, if you are in the market for a good directory with great tech support – visit his site. I hope you all can get on with your blog now!

    Good luck all.

    All right, what happened to me is weird.

    I installed my wordpress a month ago and was runing perfect. I was just testing, adding posting and learning how I could create my template.

    Today I started to update the new files for my template, everything was working fine, suddenly I try to connect to my blog and gives me the error message!!!

    I haven’t changed anything in my database. I am running my blog on media temple
    http://www.blog.escorialdesign.com

    Man I am bummed!!!

    I’ve found the same problem in my installation – if I use MySQL5, WP can’t find the database. If I use MySQL4, it works just fine, but when I tried to convert to MySQL5, once again, I had issues with WP trying to find the DB.

    Is there an issue with the collation/encoding? My host defaults to latin1_general_ci for MySQL5 collation. MySQL4 is cp1252

    Should I just get used to using MySQL4, since it works?

    I struggled with this as well.

    Try this as your host in wp-config.php:

    localhost:/tmp/mysql5.sock

    So you should have a line in wp-config.php like this:
    define(‘DB_HOST’, ‘localhost:/tmp/mysql5.sock’);

    Worked for me.

    cheers.

    marc

    i just had the database connection issue sited at the top of this post and one of the options suggested was to change localhost to your domain. my host said it makes mysql work a bit harder and it is considered a security risk to make your mysql accessable to internet. for me the solution was the correct query from my host provider.

    RonChicago, the domain name solution was suggested above by Tower180 – I tried that. It didn’t work.

    Shortly after I had this trouble with WP, I installed Drupal on one of my other sites, and had similar trouble with the databases, only to find that the problem stemmed from my server using an unusual port number for the MySQL5 database. Drupal made it easy to change the port number, but I haven’t figured out where that is set in the WP setup. I’m leaning toward trying MarcDelange’s syntax to see if that fixes the trouble.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Can’t Select Database’ is closed to new replies.