WordPress.org

Forums

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

  1. Hades666
    Member
    Posted 2 years 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. Patrick Nommensen
    Multisite Master
    Posted 2 years ago #

    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 2 years ago #

    It is SharDB.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags