On Thu, 16 Apr 2009 00:50:46 +0200, Platonides wrote:
I don't really know about this, but perhaps you
can do a GRANT ALL/GRANT
SELECT as Bar to user Foo for Bar's db? Although as GRANT OPTION is not
included by GRANT ALL it might not be available, but it's worth trying.
Thanks for replying. However, I did already try various mysql commands
to circumvent my shared host's limitations on my db names and usernames,
including GRANT. It appears that they have made the mysql installation
options such that shared host users do not have any permission to use
the GRANT command at all. Other than changing the user passwords (only
through a host supplied interface, not by use of mysql itself) all that
I am given when the db is created are three usernames: xxx, xxx_w and
xxx_r (where xxx is my account username with the host) with separate
passwords for each, which enable respectively create, delete, change,
write tables; just writing and reading; or merely reading. Everything
works fine with any one wiki and I have already easily successfully
exported and imported individual tables.
At the moment I see no solution but to change the code so that the
username (at least) is also changed to the common one whenever the
shared tables are accessed. While I am doing this I figure I might as
well make the change to also enable a different db host (the common one)
to also be used. However, my biggest concern at this point is that I do
not see how the JOIN mysql command can work if the tables are not in a
common db (which appears to be allowed by the mediawiki LocalSettings
parameters) unless perhaps the tables that one would normal want to
share (mainly "user" and "usergroups" are never used with a JOIN
command
(something that is not at all clear from the mediawiki code).
To satisfy this concern (about the JOIN command - which I really need to
do before I start trying to make the necessary coding changes), I would
really like to know if there is a mediawiki installation which currently
used shared tables on one dd with the other tables of at least one of
the wikis using this shared table being on an entirely separate db.
--Paul