Would still love some help with this, thanks.
you dont. especially since sharing the same database across sites that exist on separate servers probably isnt an option — unless youre going to tell me that you are not on shared hosting, or that you happen to have all the sites hosted with the same company, but on separate servers, and that they all use the same mysql server.
Shared hosts rarely, very rarely allow remote mysql connections, for obvious reasons.
Godaddy clusters and has dedicated mysql servers, so while 3 accounts on godaddy might be on different servers, they *might* also all use the same mysql server.
Follow?
No go.
Even IF you got over those hurdles you have the issue of cookies. Just having logged in doesnt matter. Disable your cookies after you have logged in and see what happens.
No, no, they’re able to connect. I”m on a bunxh of different resellers and stuff. I’ve got them to share the same database already, just want to get them to use the same “wp_” user list.
There just HAS to be a way to do it.
It’s possible to share tables across databases under mysql. You hard link (not symlink) the files associated with the table you want to share, in this case, wp_users.frm, wp_users.MYD, and wp_users.MYI. Doing this requires root access on a linux server. It can’t be done on a windoze box.
User access levels would be identical across all wordpress installs, so one rogue with admin access could do all kinds of damage across multiple blogs.
WARNING, this is not something to attempt if you are not highly competent with Linux and MySQL!!!
How could I go about doing this?
Add these to your wp-config.php files, along with the other defines:
define('CUSTOM_USER_TABLE','wp_users');
define('CUSTOM_USER_META_TABLE','wp_usermeta');
That will force the user and usermeta tables to all use the same tables. All the installs must be using the same database already, but with different prefixes.
However, this will not let you log in at one and then be logged in at the others as well. It only means that they will share usernames and passwords and such. The login cookie is specific to each site. There is no way around that.
Otto’s suggestion is much better than mucking about with hard linking mysql table files and doesn’t require special access, so go with his suggestion and ignore mine.
That doesn’t appear to work in 2.6 — that is, it’s definitely looking at the other installation’s user tables, but I get “You do not have sufficient permissions to access this page” when logging in as one of the other installation’s (admin) users.
ETA: Does work if you alter wp-includes/wp-capabilities.php as described here.
Make sure you upgrade all the blogs at the same time. 2.6 adds some new capabilities to the administrator role. They might be interfering if all the installs don’t understand them.
