Need Help!!! WordPress can not connect to database

  • I am running this on my own windows 2003 server. I have installed Mysql, PHP, and wordpress.

    I have tested my PHP, this works fine. I can log in to mysql database using mysql admin software, shows it is running. I have set all of the proper information in the wp-config.php.

    But when i go to my url to do the install.php i keep getting wordpress can not connect to my database.

    I have read forum after forum and tried everything. Can anyone help me, i would be so appreciative.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)

  • link?

    You probably want to first make sure/confirm that your PHP can talk to mysql before . As I recall from some experimenting last year, there are some wrinkles when doing this on Windows servers.

    Have you installed phpMyAdmin? If so, can IT connect? If not, some googling should turn up what you need to do.

    Thread Starter sunfirenet

    (@sunfirenet)

    I am actually using the mysql administrator gui. Which shows that mysql server is running. I can log in thru that into the wordpress database that i have created.

    I have no clue what the “mysql administrator gui” is — is it using PHP to connect to the database and running in a web browser?

    If so, groovy, that’s working.

    If not, then see my earlier post (I was suggesting phpMyAdmin simply because it is a flexible PHP app to use to try and connect to MySQL).

    It is likely that you are running into a conflict with password hashing. If you’re using MySQL 5, it employs a password hashing algorithm completely different from previous versions. To find out if this is the problem, open wp-includes/wp-db.php. On line 43, you will see this text:

    $this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);

    Take out the “@” as this supresses errors and retry the installation. If you are experiencing the password hashing issue, you will see the following warning:

    Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in …

    If so, then you’ve found the problem. Go ahead and add the “@” back into line 43 and follow the MySQL instructions for fixing this problem. They are located here:

    https://dev.mysql.com/doc/refman/5.0/en/old-client.html

    Hope this helps.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Need Help!!! WordPress can not connect to database’ is closed to new replies.