mySql on Windows 2008 server/IIS7
-
I’ve read through the forums, I’ve been googleing for 2 days straight now trying all the videos and forums out there. I think my problem is common, but I can’t figure out how to fix it!
I’ve installed PHP and it works. I’ve tested it using a test.php page on my site. I’ve installed mySQL (essential v5.1.46 for windows) and the service is running and I can connect to it via MySQL Administrator tool in the gui tools package. The Word press database is created and I’ve added a user to it called ‘admin’.
I’ve gone through the php.ini file and made sure the mysql extensions are enabled. I’ve updated all paths that need updated (that I’m aware of). My problem is I keep getting the “cannot establish connection to database”. No matter what combination of commands I use (localhost, intranet(name of server), intranet.domainname.com, the IP address) it will not connect to the mySQL server. I think it really doesn’t like the ‘localhost’ name but I have no idea what to use at this point.
I installed phpmyadmin and it comes up and allows me to login. I use the root user and password and it comes back with the message: “#2002 Cannot log in to the MySQL server” followed by “Connection for controluser as defined in your configuration failed.”
And of course wordpress just gives me the standard error you all have seen a thousand or more times.What the heck am I doing wrong? I did not change the default port, the firewall is disabled on this server. Is there any piece of information I can give one of you to help me get this working?
Here is my wp-config.ini file:
// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘wordpress’);/** MySQL database username */
define(‘DB_USER’, ‘admin’);/** MySQL database password */
define(‘DB_PASSWORD’, ‘test’);/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);/** The Database Collate type. Don’t change this if in doubt. */
define(‘DB_COLLATE’, ”);define(‘WP_DEBUG’, ‘true’);
- The topic ‘mySql on Windows 2008 server/IIS7’ is closed to new replies.