I have three different subdomains' blogs running off a single WordPress database. The blog content on each is meant to be different so a different table prefix is assigned to each subdomain.
User registration is required for posting. I don't want users to have to register three times: just register once and be a registered user of each subdomain's blog.
I had the brilliant (?) idea that I could just create symbolic links for the users and usermeta table to that for the main subdomain. I then set ownership and group permissions to mysql. All would then work... or so I thought. It doesn't.
I get the "You do not have sufficient permissions to access this page." when logged in as admin (which is a registered user in each subdomain). I can access each users table's data without problems in webmin.
Anyone know how to get this to work right in WordPress? My suspicion is that I missing the obvious answer here.