Error establishing a database connection

  • tjmphd

    (@tjmphd)


    21 years, 5 months ago

    Okay, so I could use some assistance from any kind soul.

    I have MySQL 4.1.9 installed, PHP 4.3.10, and Abyss Web server 1.1 all up and running. I modified the wp-config.php file to point to a new database I created (“texan”). I ensured that I did aUSE command to use the database “texan.” I try to run the install.php but get this error over and over. I am using root and the password, so I know that’s right. Can somebody assist??

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter tjmphd

    (@tjmphd)

    21 years, 5 months ago

    And by the way, this is all running on a personal server I have here in my own office (I am experimenting). All I have is the console access to issue SQL commands…

    mycw

    (@mycw)

    21 years, 5 months ago

    If you’re using PHP 4.3.9 and MySQL client/server 4.1 you may actually get the following error while connecting during installation.

    Error w/ php: mysql_connect(): Client does not support authentication protocol

    You can verify this problem by editing wp-includes/wp-db.php. Look under function wpdb. Change the last line in the ‘die’ statement to
    </div>” . mysql_error());
    i.e adding mysql_error() so you actually see the MYSQL error.

    If you get the above MYSQL error then you can fix this by doing logging into mysql and do the following:

    SET PASSWORD FOR ‘user’@’localhost’ = OLD_PASSWORD(‘password’);

    Also checkout: http://forums.mysql.com/read.php?11,6400,6701#msg-6701

    This fixes the “Error establishing a database connection” problem for me.

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

The topic ‘Error establishing a database connection’ is closed to new replies.