|
womble -> MySQL user permissions problem (2/16/2007 14:49:55)
|
Short version of my problem:
I'm trying to convert a phpBB forum to an SMF one and at the same time moving it to a new domain (the lovely folks at SMF have been helping me out with the practicalities of moving it). I've hit a problem with it though and all's gone quiet over there, so I wondered if anyone with MySQL experience has any ideas?
I have a databse dump of the phpBB formum, the tables for which have been imported into the database of the new SMF forum. Database has the tables for both forums in it, but when I run the conversion tool to convert the phpBB tables into the SMF format, I get an error message telling me that the MySQL user for the new forum db doesn't have permission on a particular table.
Problem is I can't just add the MySQL user to the db because if I do it through the cPanel it gets a prefix added to the username (as the two dbs are from different hosts on different domains, the prefix is different).
Then I had a brainwave and decided to try it by running an SQL query in phpMyAdmin. I tried granting all privilidges to the MySQL user on that table:
GRANT ALL
ON databasename.phpbb_users
TO username@localhost
IDENTIFIED by "password";
No go - this was the error message I got:
quote:
MySQL said: Documentation
#1132 - You must have privileges to update tables in the mysql database to be able to change passwords for others
Having now exhausted by knowedge of MySQL, I'm at a loss as to what to try next.
Anyone any ideas? Or would this be something my hosts could do at server level?
|
|
|
|
