16 points
Community rank #3609
drewehart
SophomoreJust Getting Started
MemberLikes (0)
Okay, when you go to my site, allthingsin.com, this is what you get (this is a fresh install of mu on psek hosting with a dedicated IP):
Warning: mysql_get_server_info() [function.mysql-get-server-info]: Access denied for user 'allthing'@'localhost' (using password: NO) in /home/allthing/public_html/wp-content/db.php on line 705
Warning: mysql_get_server_info() [function.mysql-get-server-info]: A link to the server could not be established in /home/allthing/public_html/wp-content/db.php on line 705
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the database.
Warning: mysql_get_server_info() [function.mysql-get-server-info]: Access denied for user 'allthing'@'localhost' (using password: NO) in /home/allthing/public_html/wp-content/db.php on line 705
Warning: mysql_get_server_info() [function.mysql-get-server-info]: A link to the server could not be established in /home/allthing/public_html/wp-content/db.php on line 705
After two days spent on the multi-db plugin I can barely read anything anymore:) HELP:) I can't even log into admin. If someone would give me an email I would be happy to supply passwords, etc. I am having problems with the multi-db plugin, but since I can't install it and can't access my wp admin, I can't even select it from the help choices here. Thanks,
6750 pointsCommunity rank #8Supreme DeityWPMU DEV StaffLifetime member
Developer
(joined June 2008)
Likes (0)
Warning: mysql_get_server_info() [function.mysql-get-server-info]: A link to the server could not be established in /home/allthing/public_html/wp-content/db.php on line 705
That means that the database user and password you have set up in your db-config.php file for the database isn't correct.
Have you completed the following? :
1. created all of the databases
2. created a user with password
3. granted full permissions to each database for the new user
4. run move-blogs.php to move the existing tables to the correct places
5. then you should copy the db-config.php and db.php to the wp-content directory.
In the meantime, can you post your db-config.php file here so we can take a quick look?
16 pointsCommunity rank #3609SophomoreJust Getting Started
Member
(joined September 2011)
Likes (0)
I can't seem to reply, let's try again:
It is a brand new setup done by Psek last week (it took a little while as I added a wildcard SSL for future blog owners so they can have stores, etc.). I have done nothing to it other than installing plugins. Psek (whom you recommended) is awesome - all the setup so far was done by them. I verified by hand that all databases have full access with the user and pass I gave you - though I got the pass from wp-config as Psek didn't have it, but I believe that should be fine. I sent you the db-config file. Many thanks,
16 pointsCommunity rank #3609SophomoreJust Getting Started
Member
(joined September 2011)
Likes (0)
Yes, reading it several times as advised:) I think I could quote that page from memory at this point:) I did get hung up for a while on what "global" was, but finally realized that meant the original database created when WPMU was installed. I also got hung up on DB permissions, but fixed that.
6750 pointsCommunity rank #8Supreme DeityWPMU DEV StaffLifetime member
Developer
(joined June 2008)
Likes (0)
I did get hung up for a while on what "global" was, but finally realized that meant the original database created when WPMU was installed.
No, sorry that's very wrong. The original database doesn't get used at all when you have multi-db going. Global is a new database that holds the global tables.
For your install you should have (say for example a 16 db install) 16 databases + 1 global database (plus the original WP database you started with).
6750 pointsCommunity rank #8Supreme DeityWPMU DEV StaffLifetime member
Developer
(joined June 2008)
Likes (0)
BTW - that message still means that the user you have setup in your db-config.php doesn't have permissions to log into a database it is trying to log in to, so you are going to find that either you have the username and password wrong in your db-config, or you haven't set the permissions correctly on all of the databases you have set up.
16 pointsCommunity rank #3609SophomoreJust Getting Started
Member
(joined September 2011)
Likes (0)
The permissions should be correct. I actually did them manually through Cpanel - 256 times, I added the user to each DB, clicked add, clicked all permissions and clicked make changes. Since this is identical to the setup of the global database, it should be correct. I wish it was that since that was like a 6 hour project - doing 256 individually and by hand, but I think they are all correct. There was a point were my permissions were wrong, but I don't think that is the case now. I know if you remove the multi-db stuff, the site does work so the problem must be in the config file or something, but for the life of me I can't figure out what the problem is - and I have read many other posts on here in addition to the instructions.
16 pointsCommunity rank #3609SophomoreJust Getting Started
Member
(joined September 2011)
Likes (0)
All the databases are assigned the proper user - that is easy to visually verify and I have checked it several times. It is quit possible that I missed giving permissions to one or two databases, simply because I did it by hand and there were so many - definitely possible I made a mistake, but I wouldn't think one or two would crash the whole thing. At any rate, they all look good, but I will go into each one today and double check, though I do think they are good. If anyone knows of a good sql command or way to check this in phpmyadmin without having to open 256 records that would be cool:)
Responses (14)
Developer (joined June 2008) Likes (0)
That means that the database user and password you have set up in your db-config.php file for the database isn't correct.
Have you completed the following? :
1. created all of the databases
2. created a user with password
3. granted full permissions to each database for the new user
4. run move-blogs.php to move the existing tables to the correct places
5. then you should copy the db-config.php and db.php to the wp-content directory.
In the meantime, can you post your db-config.php file here so we can take a quick look?
WPMUDEV-ian (joined November 2011) Likes (0)
Heya Drew,
Thanks for providing the information in the email. I have received it and checking it now.
I would like to know a few things about your setup, whether it is new or old ? I mean have you got a Live site or you just started ?
Please advise
Cheers
PC
Member (joined September 2011) Likes (0)
I can't seem to reply, let's try again:
It is a brand new setup done by Psek last week (it took a little while as I added a wildcard SSL for future blog owners so they can have stores, etc.). I have done nothing to it other than installing plugins. Psek (whom you recommended) is awesome - all the setup so far was done by them. I verified by hand that all databases have full access with the user and pass I gave you - though I got the pass from wp-config as Psek didn't have it, but I believe that should be fine. I sent you the db-config file. Many thanks,
WPMUDEV-ian (joined November 2011) Likes (0)
Thanks for the info Drew.
I am gonna look into it and would post as soon as I have some suggestions for ya !
Cheers
PC
WPMUDEV-ian (joined November 2011) Likes (0)
Hey Drew,
Just a quick question,
Did you follow the instructions here before uploading the plugin to your site ?
Please advise
Cheers
PC
Member (joined September 2011) Likes (0)
Yes, reading it several times as advised:) I think I could quote that page from memory at this point:) I did get hung up for a while on what "global" was, but finally realized that meant the original database created when WPMU was installed. I also got hung up on DB permissions, but fixed that.
Developer (joined June 2008) Likes (0)
No, sorry that's very wrong. The original database doesn't get used at all when you have multi-db going. Global is a new database that holds the global tables.
For your install you should have (say for example a 16 db install) 16 databases + 1 global database (plus the original WP database you started with).
Developer (joined June 2008) Likes (0)
BTW - that message still means that the user you have setup in your db-config.php doesn't have permissions to log into a database it is trying to log in to, so you are going to find that either you have the username and password wrong in your db-config, or you haven't set the permissions correctly on all of the databases you have set up.
Member (joined September 2011) Likes (0)
The permissions should be correct. I actually did them manually through Cpanel - 256 times, I added the user to each DB, clicked add, clicked all permissions and clicked make changes. Since this is identical to the setup of the global database, it should be correct. I wish it was that since that was like a 6 hour project - doing 256 individually and by hand, but I think they are all correct. There was a point were my permissions were wrong, but I don't think that is the case now. I know if you remove the multi-db stuff, the site does work so the problem must be in the config file or something, but for the life of me I can't figure out what the problem is - and I have read many other posts on here in addition to the instructions.
Member (joined September 2011) Likes (0)
All the databases are assigned the proper user - that is easy to visually verify and I have checked it several times. It is quit possible that I missed giving permissions to one or two databases, simply because I did it by hand and there were so many - definitely possible I made a mistake, but I wouldn't think one or two would crash the whole thing. At any rate, they all look good, but I will go into each one today and double check, though I do think they are good. If anyone knows of a good sql command or way to check this in phpmyadmin without having to open 256 records that would be cool:)
Member (joined September 2011) Likes (0)
I did misunderstand what global was then - let me try it given the new information. Will post results. Thanks,
Drew
WPMUDEV-ian (joined November 2011) Likes (0)
Sure. Thanks Drew.
Member (joined September 2011) Likes (0)
Sorry, busy at the job, will probably have to give it a try tomorrow, just so you know I am still working on it. Many thanks,
Drew
WPMUDEV-ian (joined November 2011) Likes (0)
You are welcome and thanks for letting us know Drew :)
Cheers
PC
Become a member