Nomad of Norad (David C Hall) wrote:
> >>
* Granting user permissions to wikiuser on
joshua-w_wiki...Query
> >> "GRANT
DELETE,INSERT,SELECT,UPDATE ON `joshua-w_wiki`.* TO
> >> 'wikiuser'@'%' IDENTIFIED BY 'pl0p!' " failed
with error code
"Access
> >> denied for user:
'joshua-w_wiki@localhost' to database
'joshua-w_wiki'
>>
(localhost)".
Create a user and grant them permissions on the database, then use
that username and password as the connection username and password
during installation.
Well, in vDeck (Website administration Web interface), when I pull up
the Databases screen, from what I see under the banner "set db
permissions for user joshua-w_wiki" it appears I already have all the
permissions set for the database joshua-w_wiki. I see checkboxes for
Select, Insert, Update, Delete, Create, Drop, Index, and Alter, plus a
Check All checkox that, when selected, causes all the other checkboxes
to get checked.
It has been set to the above from the beginning.
Am I missing something here? Is there a hidden function or screen
inside phpMyAdmin that further enables this stuff?
Well, doing a google on "grant-delete-insert-select-update-on failed"
leads me to here:
http://mail.wikipedia.org/pipermail/mediawiki-cvs/2005-August/010681.html
...where it states:
<quote>
Log Message:
Fix #1734: failed grant with usernames having a -.
</quote>
Looks like this is the problem. I have a username with a dash in.
Unfortunately, going without the dash is not an option: My webspace
provider, when generating things for internal usage at the website, only
gives me the option of appending something to the end of a fragment of
username that has a dash in it, rather than generating a whole new
username from the get go.
Is there a way around this can't-use-a-username-with-a-dash problem?
--
Nomad of Norad (David C. Hall) --- *TeamAmiga*
nomad(a)joshua-wopr.com ---
http://www.joshua-wopr.com/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
For a dementedly wacky sci-fi continue-the-story project,
join my WebBBS.
http://www.joshua-wopr.com/phpBB/index.php
----------------------------------------------------------
This is the Emergency Backup .Signature File, it kicks in
if the Regular Backup .Signature File fails to load.