So I have a new problem... Im installing multidb for a friend, Ive done this plenty of times now on my own systems so I figured it would work the same way....guess every system is diffrent.
The problem is this: I log into phpmyadmin and run through the script to create db entrys.. I did this both with and without root, both shows that the databases were created fine... I glanced at the db listings in phpmyadmin and everything looked fine to me... so I followed up by adding a user to all the dbs and that also showed it completed fine... I then went through the steps to the move blogs area and it worked fine too green down the board. Only problem was it didnt work.... I had errors every time I created a blog in wordpress...
So I looked again this time in mysql.... only db that was showing up was the original wordpress one... I even went crazy and tried recreating one of the dbs using mysql and I get an error saying the db already exists...even though it dosent show it.
So Ill admit... Im completly lost here, I know I have the right _extension I know the dbs are being created I just dont know what is going on after that.... I did find the following however:
The wordpress db that worked with the autoinstall that I didnt create, as well as any db I create via mysql or that sql wizard tool has this for the privileges for the overall account owner:
domain localhost wildcard: user\_% ALL PRIVILEGES No Edit Privileges Edit Privileges
database-specific ALL PRIVILEGES No Edit Privileges Edit Privileges
that is 2 lines but both under domain so the database specific thing lines up with wildcard
Now the databases I create in phpmyadmin dont have the database-specific stuff just the wildcard stuff
Has anyone ever run across this problem before? or have any ideas how to fix it.