ecedelson

Forum Replies Created

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

  • Solved – somehow the user’s privileges had been removed. I restored them and all’s well.

    I have a related issue (I think), but my php, mysql and mysql client are all up to date.

    All worked fine until I changed over to mysql 4.1.14 (not the standard OSX install that was running when I installed WP) and now the WordPress PHP scripts can’t find mysql:
    “Error establishing a database connection, etc.”

    Short story: mySQL is running, database is ok, but I think PHP is looking for the old instance of mySQL which is not running, and I don’t know how to redirect it.

    Details:
    mysql 4.1.14, php 4.3.11, apache and wp1.5.1.3 on OSX 10.4.4, with a static IP.

    wp-config.php has correct login and password (nothing’s changed)
    mysql is running — I can connect from command line and MySQL Administrator
    ps shows: /usr/local/mysql/bin/mysql is running
    this is the new version I installed

    phpinfo() shows: support is enabled for /var/mysql/mysql.sock
    but MySQL Administrator says the instance of mysql actually running uses /tmp/mysql.sock
    phpinfo() shows: Client API version 4.1.13a
    but MySQL Admin says MySQL Client Version 5.0.4

    So I think PHP is looking for the old instance of mySQL.

    I edited /etc/php.ini: mysql.default_socket = /tmp/mysql.sock — no luck

    I reset the password manually – probably not necessary:
    set password for ‘wpuser’@’localhost’=OLD_PASSWORD(‘xxxxxxxx’); — nope

    I tried setting define(‘DB_HOST’, ‘my.host.com’); — No luck

    Added “Error: $my_errstr;” to the code in wp-db.php but it doesn’t report anything.

    I flushed the browser cache each time.

    Running out of ideas.
    Thanks in advance for your time.

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