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 -- Steve Holdoway <[EMAIL PROTECTED]>
