Hi, I posted early this a.m. but haven't received any answer.
I got blog1 up and running last week.
I have another (add-on) domain in my hosting account and wanted blog2 there. The two URLs should be completely different: blog.domain1.com and blog.domain2.com.
So I created a second database (not a second table) for blog2 and added wordpress as a user.
I installed WP in a new folder named blog, under domain2, which of course in my file system is under domain1.
Pictorially the file hierarchy is like this:
-public-html (for main acct, domain1.com)
--domain2 (appears in browsers as domain2.com)
I log into blog2, set up permalinks and the URIs. But all of a sudden I see my info for blog1. I freak out. I click "view site" and see blog1. I can't get the admin page or the blog of blog2.
I open blog2's wp-config file and inexplicably, the database is db1 - not db2 that I set up! I change it. But now I go to blog1 and I see blog2, the other way around! My config file permissions are 644 so how are they being changed?
I tried creating a second user for db2 instead of sharing one "wordpress" user. No effect. I used phpMyAdmin to make sure the site and home fields were correct, and they were for both databases.
Please, somebody, tell me what is happening, what I did wrong, and what I must do to fix it!