Nomad of Norad (David C Hall) wrote:
* Granting user permissions to wikiuser onjoshua-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?