WordPress.org

Ready to get started?Download WordPress

Forums

WPMU - No site defined. Access denied errors 1045. (3 posts)

  1. Hades666
    Member
    Posted 7 months ago #

    Hi there,

    We are migrating datacenters and I have synced all teh web directories to the new server and restored all the mysql Databases.

    Mysql is up and running and I can connect. I created the wpdb account in mysql. He has full rights.

    What am I missing here.

    [root@prd ~]# mysql --host=localhost --port=3306 -u wpdb -p
    Enter password: ****
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 31720
    
    mysql> use wpmu_global;
    
    Database changed
    mysql> SELECT * FROM wp_site WHERE domain = 'site.com' AND path='/';
    +------+-------------------+------+
    | id   | domain            | path |
    +------+-------------------+------+
    |   53 | site.com | /    |
    | 4470 | site.com | /    |
    +------+-------------------+------+
    2 rows in set (0.00 sec)
    
    mysql> exit

    Web Browser shows this:

    Unable to connect to localhost:3306 while querying table 'wp_domain_mapping' (global_r)Unable to connect to localhost:3306 while querying table 'wp_site' (global_r)Unable to connect to localhost:3306 while querying table 'wp_site' (global_r)Unable to connect to localhost:3306 while querying table 'wp_site' (global_r)

    No site defined on this host. If you are the owner of this site, please check Debugging a WordPress Network for help.

    Apache is showing hte follow repeated error.

    [Fri Jan 10 23:24:33 2014] [error] [client 8.21.21.10] WordPress database error 2014-01-11 04:24:33 Can't select global_r - \nArray\n(\n    [referrer] => site.com/\n    [host] => localhost\n    [error] => Access denied for user 'wpdb'@'localhost' (using password: YES)\n    [errno] => 1045\n    [tcp_responsive] => true\n)\n for query SELECT * FROM wp_site WHERE domain = 'site.com' AND path='/' made by wpmu_current_site
    [Fri Jan 10 23:24:33 2014] [error] [client 8.21.21.10] PHP Warning:  mysql_connect(): Access denied for user 'wpdb'@'localhost' (using password: YES) in /data/www/site.com/wp-content/db.php on line 478
    [Fri Jan 10 23:24:34 2014] [error] [client 8.21.21.10] PHP Warning:  mysql_connect(): Access denied for user 'wpdb'@'localhost' (using password: YES) in /data/www/site.com/wp-content/db.php on line 478
    [Fri Jan 10 23:24:35 2014] [error] [client 8.21.21.10] PHP Warning:  mysql_connect(): Access denied for user 'wpdb'@'localhost' (using password: YES) in /data/www/site.com/wp-content/db.php on line 478
    [Fri Jan 10 23:24:36 2014] [error] [client 8.21.21.10] PHP Warning:  mysql_connect(): Access denied for user 'wpdb'@'localhost' (using password: YES) in /data/www/site.com/wp-content/db.php on line 478
    [Fri Jan 10 23:24:36 2014] [error] [client 8.21.21.10] WordPress database error 2014-01-11 04:24:36 Can't select global_r - \nArray\n(\n    [referrer] => site.com/\n    [host] => localhost\n    [error] => Access denied for user 'wpdb'@'localhost' (using password: YES)\n    [errno] => 1045\n    [tcp_responsive] => true\n)\n for query SELECT * FROM wp_site WHERE domain = 'site.com' AND path='/' made by wpmu_current_site

    Any help would be appreciated.

  2. Are you using SharDB or HyperDB? You may want to ask in that plugins forum so the developers can help you.

  3. Hades666
    Member
    Posted 7 months ago #

    It is SharDB.

Reply

You must log in to post.

About this Topic

Tags