#55 installation problem (DB Error)

1.3.x
closed
nobody
None
5
2012-10-11
2003-09-17
Anonymous
No

Does anybody know how to solve this problem?

lib/WikiDB/backend/PearDB.php:681: Fatal[256]:
wikidb_backend_mysql: fatal database error

DB Error: unknown error
(LOCK TABLES page WRITE,version WRITE,link
WRITE,recent WRITE,nonempty WRITE
[nativecode=1044 ** Access denied for
user: 'xyz@localhost' to database 'phpwiki']
)

lib/config.php:276: Notice[8]: Undefined variable:
SCRIPT_NAME

I recompiled PHP(v4.3.3) with "with-mysql" option, and
Apache 2. 0.47 with dynamic PHP module, but still got
the same error. mysql is v4.0.14.

Thanks a lot.

Discussion

  • Logged In: NO

    need to grant permision on "lock tables" in addition to "insert,
    delete, ...", if running mysql version 4 or above.

     
  • Fatman
    Fatman
    2003-11-30

    Logged In: YES
    user_id=906200

    I got that until I realised I hadn't read the INSTALL.mysql
    file properly. You'll need to run something like:

    mysql -hHost -uUsername -pPassword dbname <schemas/mysql.sql

    after making sure database "dbname" exists, of course.