| Please grant your database user access to drop tables and try again. [message #164548] |
Wed, 16 February 2011 19:14  |
Bradley
Messages: 41
Registered: February 2011
Karma: 0
|
Member |
|
|
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 #164550 is a reply to message #164549] |
Wed, 16 February 2011 19:49  |
Bradley
Messages: 41
Registered: February 2011
Karma: 0
|
Member |
|
|
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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]