WordPress.org

Support

Support » Multisite » WPMU – No site defined. Access denied errors 1045.

WPMU – No site defined. Access denied errors 1045.

  • 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.

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WPMU – No site defined. Access denied errors 1045.’ is closed to new replies.
Skip to toolbar