Updated MySQL, 500 Internal Server Error

  • Garacesh

    (@garacesh)


    10 years ago

    We tried to move our WordPress site from our dev.domain.uk address to just domain.uk. We contacted the upstream DNS and updated the records to point from the old server to the new one, then logged in to the WP Control panel and changed the url from dev.domain.uk to domain.uk. Things started to go downhill from there and we weren’t able to access the vast majority of our content due to ridiculous WAN routing rules.

    Other posts on the WP forums indicated you could use PHPMyAdmin to modify the database and change the address, so that was the plan. So I downloaded and extracted PHPMyAdmin with the intention of reverting to dev.domain.uk and login with the details I set up whilst setting up WordPress (Which it turns out are NOT the details stored in the wp-config.php file). PHPMyAdmin then informed me I needed to update to MySQL5.5.0 or higher.

    So, I downloaded and installed MySQL 5.5.42, which is apparently the latest version, uninstalled the older version and restarted the server. PHPMyAdmin now says the credentials are incorrect (using both the ones I used at WordPress setup and the ones in wp-config.php) and what’s worse, I’m getting HTTP 500 errors when trying to access the site (from both its IP from another machine and https://localhost/ from the server)

    Wipe 5.5.42, revert to 5.1.73 (as 5.1 was the original version on there), remove PHPMyAdmin – no dice. Still getting HTTP 500 errors. I’ve reverted the entire WordPress directory back to its latest backup (which was at 1am this morning, way before any of these changes were made) and yet still I’m getting HTTP 500.

    Some Google searching has recommended ‘checking the database is correct’ but from what I can gather WordPress doesn’t actually use a central database (and there isn’t a whole lot of documentation about it, either..) so that hasn’t really helped a great deal.

    I’ve re-downloaded wordpress and copied all the files out, then replaced the WP-Content and wp-config.php with files from the backup. Still no cigar.

    At a complete loss now. Anybody battled similar situations?

    Windows 2012 R2 on VMware (x64) with IIS, 4GB RAM, 2.40GHz CPU, WordPress 4.1.1, MySQL 5.1.73/5.5.42

Viewing 7 replies - 1 through 7 (of 7 total)
  • javawpscript

    (@javawpscript)

    Are you doing this on a Local Machine?

    catacaustic

    (@catacaustic)

    What is the actual error that you’re getting? The error logs on your server will tell you that. If you don’t have error logs (you should…) you can set define( 'WP_DEBUG', true ); in yoru wp-config.php file` and that will show the erorrs to you on your page.

    Thread Starter Garacesh

    (@garacesh)

    @javawpscript No, it’s hosted on a Windows Server 2012 R2 virtual machine.

    @catacaustic thanks for that.

    Warning: mysql_connect(): No connection could be made because the target machine actively refused it. in C:\inetpub\wwwroot\wordpress\wp-includes\wp-db.php on line 1416

    1415 if ( WP_DEBUG ) {
    1416 $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
    1417 } else {
    1418 $this->dbh = @mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
    1419 }

    catacaustic

    (@catacaustic)

    No connection could be made because the target machine actively refused it.

    That’s your problem.

    Your database server is saying “no” to the connection attempts, so your web server can’t communicate with it. Get that fixed and you should get your problems fixed up. That’s most likely a firewall or MySQL configuration issue, so that would be the first place that I’d look. The MySQL logs should also tell you more about why the connection was refused in the first place.

    Thread Starter Garacesh

    (@garacesh)

    Aye, I figured that was my problem. What I’m in the dark about is how to actually fix it (or where else to start looking) as I have barely any SQL experience at all. I was just told “Get a website working.” and that was it.

    Windows Firewall is actually disabled as we’re on a domain with a dedicated firewall, and I wouldn’t have a clue where to start with checking the MySQL config.
    Launching the MySQL Command Line Client gives the error

    Could not open required default file: C:\Program Files (x86)\MySQL Server 5.1\my.ini
    Fatal error in defaults handling. Program aborted.
    Enter password:

    Entering any string (whether it be the password or not) causes the CLI to close without any further messages.

    catacaustic

    (@catacaustic)

    That’s something that is way beyond the scope of these forums, and I have to admit that I am not quite so sure of where to start with it myself.

    I’d suggest looking at the MySQL Documentation, and a couple of MySQL-based forums. You will most likely have a lot more luck finding an answer on there.

    Thread Starter Garacesh

    (@garacesh)

    Well, I appreciate the help anyway. It’s refreshing to have issues about a Windows box and not half half the replies “lol install it on linux” (Which I have tried to do, twice, on a dedicated LAMP server and it just wasn’t having it.)

    Thanks for your time.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Updated MySQL, 500 Internal Server Error’ is closed to new replies.