FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Please grant your database user access to drop tables and try again. (stuck on this error)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Please grant your database user access to drop tables and try again. [message #164548] Wed, 16 February 2011 14:14 Go to next message
Bradley is currently offline  Bradley
Messages: 41
Registered: February 2011
Karma: 0
Member
add to buddy list
ignore all messages by this user
i set up a new database user, and didn't know what to grant to it - i like to do it manually - and didn't grant drop privileges. i saw a database error, so granted drop, and hit reload, only to be taken to step 2 screen asking for db credentials, with the error message "Please grant your database user access to drop tables and try again." above the database name.

the user does have drop privilege, but can't advance in the set up.
i've tried dropping the database, to recreate it, with no luck.

as a sidenote, i think it'd be really useful if the installer listed what privileges the db user needs.
Re: Please grant your database user access to drop tables and try again. [message #164549 is a reply to message #164548] Wed, 16 February 2011 14:31 Go to previous messageGo to next message
Bradley is currently offline  Bradley
Messages: 41
Registered: February 2011
Karma: 0
Member
add to buddy list
ignore all messages by this user
interestingly, it didn't have CREATE privilege. i have no idea why it kept complaining about drop as it wouldn't be able to drop anything...
Re: Please grant your database user access to drop tables and try again. [message #164550 is a reply to message #164549] Wed, 16 February 2011 14:49 Go to previous message
Bradley is currently offline  Bradley
Messages: 41
Registered: February 2011
Karma: 0
Member
add to buddy list
ignore all messages by this user
one more after setup a few permission problems which i thought had been tested during stage 1:
Warning: fopen(....index.php) [function.fopen]: failed to open stream: Permission denied in ....include/compiler.inc on line 514

Fatal error: Uncaught exception 'Exception' with message 'Couldn't write to ....index.php.' in ....include/compiler.inc:515 Stack trace:
#0 ....include/compiler.inc(753): generate_file('root_index.tmpl')
#1 .../install.php(1166): compile_all('default', 'en')
#2 {main} thrown in ....include/compiler.inc on line 515
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Custom Avatar Queue remains after approval
Next Topic: global vars setup page
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 22:29:01 EDT 2017

Total time taken to generate the page: 0.00716 seconds