Steve Holdoway wrote:
On Fri, 30 May 2008 19:41:39 +1200
Nick Rout <[EMAIL PROTECTED]> wrote:
On Fri, May 30, 2008 at 4:24 PM, Roger Searle <[EMAIL PROTECTED]> wrote:
Steve Holdoway wrote:
Roger's Wiki has a problem
Sorry! This site is experiencing technical difficulties.
Try waiting a few minutes and reloading.
(Can't contact the database server: Access denied for user
'roger'@'localhost' to database 'wiki' (locahlost)
Is this a permission error somewhere?
yes, but not a file permissions error.It is to do with mysql's permissions.
check your mysql permissions.
google gives me this as its first choice on the subject:
http://www.databasejournal.com/features/mysql/article.php/3311731
in short preserving the database concerned is not enough, you need
some stuff that is in the mysql database too.
ok, you need to tell mysql to...
grant all permissions on wiki.* to [EMAIL PROTECTED] identified by 'password';
you probably need to sudo mysql to be allowed to do that. Use the password that
you got out of LocalSettings.php. wiki.* means all the objects ( mainly tables
) in the wiki database, [EMAIL PROTECTED] is you, the user on the local machine
that's accessing the database, and password is self explanatory.
I originally put this line into my email, but assumed ( stupid me! ) that the
installation would have already done this! Most confused why it didn't.
hth,
Steve
Thanks Steve and Nick, very useful. While understanding relational
databases to a degree and having some experience with a redmond product,
this really is my first venture into (what some people refer to as)
"real" databases, (no desire to start a religious war here) and
highlights an area where I need to do a little more reading. Very
interesting - I'm looking forward to exploring this more.
Cheers,
Roger
