• So here is something of an odd issue. Last week (3 days ago) everything was working fine. I had to make a few changes to the wp-config.php file and to the xampp server since I’m running IIS first and foremost and wordpress is essentially just for learning purposes at this time. So I modified the port of the apache server to 81 and the MySQL server to 3307. wp-config had the line define('DB_HOST', 'localhost:81'); and everything seemed to be working fine for several days, but after a weekend of the computer being off now I am having issues connecting to the database.

    I have been looking around for solutions and have made the following changes:

    1. tried changing the wp-config.php line to define('DB_HOST', 'localhost:3307');
    2. Added /mysql/bin/mysql.exe to the allowed programs list in the firewall settings
    3. Added a specific allowed port (3307) in the firewall settings
    4. modified the my.ini file in xampp to use port 3307
    5. modified the /php/php.ini file to default the database to port 3307

    None of these things seemed to work or change anything at all. I think it might have something to do with my xampp, which says “A MySQL server is not running or is blocked by a firewall!” on the https://localhost:81/security/index.php page. This is odd since the xampp control panel clearly shows that not only is MySQL running, but it is running on port 3307 just like I specified, and it is clear from my firewall changes that this should not be blocked in any way.

    Does anyone have any clue what I’ve done wrong?

Viewing 1 replies (of 1 total)
  • Thread Starter jsl245

    (@jsl245)

    So I fixed the whole “A MySQL server is not running or is blocked by a firewall!” issue by changing which port the security/index.php file was looking at to 3307. However the main issue of wordpress not finding the database still persists.

Viewing 1 replies (of 1 total)
  • The topic ‘Database connection issues’ is closed to new replies.