Error: “Error establishing a database connection”

  • bsilver

    (@bsilver)


    19 years, 7 months ago

    I’m attempting to install WordPress on my local Macintosh (Intel-based). I am having trouble with getting install.php to run; it gives the subject line as the error message and in troubleshooting tells me that perhaps MySQL isn’t running or the wp-config.php file has incorrect information.

    I triple checked the wp-config information for spaces, and when I issue the “mysql -u root -p” command I can log in as that user with the specified password just fine.

    I create a test.php file and it rendered in apache, saying it was version 4.4.1.

    My version information
    MySQL:
    /usr/local/mysql/bin/mysqld Ver 5.0.24-standard for apple-darwin8.5.1 on i686 (MySQL Community Edition – Standard (GPL))

    PHP:
    PHP 4.4.1 (cli) (built: Mar 12 2006 16:47:35)
    Copyright (c) 1997-2004 The PHP Group
    Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

    OS:
    Darwin Obi-Wan.local 8.7.1 Darwin Kernel Version 8.7.1: Wed Jun 7 16:19:56 PDT 2006; root:xnu-792.9.72.obj~2/RELEASE_I386 i386 i386
    OS X 10.4.7

    Apache is the version that came with OS X, as is the PHP modules (just uncommented some items from http.conf).

    I have one user configured in the database (root) and the only thing this database engine would be used for, as far as I know in the short term, is using this blog. Can anyone help guide me through what steps are needed to get PHP talking to the INTEL-verson of MySQL for the Mac?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Ryan Fitzer

    (@ryanfitzer)

    19 years, 7 months ago

    I’ve never tried it but this post my address you needs:

    http://wordpress.org/support/topic/60343?replies=12

    usrdude

    (@usrdude)

    19 years, 7 months ago

    I had this problem this weekend when I was setting up wordpress. i took the username and password out of the wp-config.php. I left “wordpress” as the dbname, dbuser = “”, dbpassword = “” and dbhost = “localhost”. tried it again and it started building the database and then completed. I was up and running in about 30 minutes. It did give me another admin account for the database so read everything completely before you close it.

    Thread Starter bsilver

    (@bsilver)

    19 years, 7 months ago

    Ryanfitzer: it was closely related to that thread, yes. Because Apple moved the socket file, WP threw out an error with some misleading help offered…Whoops! 🙂

    Suggestion for future releases…one of the help items should probably be to check that your socket file is located where WP is looking for it to be located.

    I resolved this in the wp-config.php file by altering a line to read,

    define(‘DB_HOST’, ‘localhost:/tmp/mysql.sock’); // 99% chance you won’t need to change this value

    Then I re-ran the install link and WP came up as if nothing were wrong.

    Thanks for the replies to my plea for assistance!!

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

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