MySQL user permissions problem

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

MySQL user permissions problem

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> MySQL user permissions problem

Page: [1]

womble

Posts: 5528
Joined: 3/14/2005
From: Living on the edge
Status: offline

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?

_____________________________

~~ "A cruel god ain't no god at all" ~~


womble Posts: 5528 Joined: 3/14/2005 From: Living on the edge Status: offline	RE: MySQL user permissions problem - 2/18/2007 15:35:57 Just incase anyone ever runs into similar problems with MySQL databases, I eventually managed to get this fixed yesterday. I ended up installing phpBB on the new domain, installing into the same database as SMF was using, so both had the same MySQL user accessing all the tables. I then emptied the phpBB tables using phpMyAdmin and restored a database dump of only the data, not the table structure, from the original phpBB forum into the phpBB tables in the new database. From there I could just run the SMF converter tool and had no more problems with user permissions, and I now have a fully functioning forum with no data loss...and just a few members complaining they liked the old software better.... sigh My response? "I'm admin. I like it. Get used to it!" _____________________________ ~~ "A cruel god ain't no god at all" ~~ (in reply to womble)