I'm using Apache 1.3 under WinXP with PHP 4.3.4 and MySQL 4.0.
I have created the DB called 'phpwiki' and the 'wikiuser' user with rights to that DB using the mysql schema.
As I see all the httpd, php and DB is right. I have configured index.php with SQL database:
'dbtype' => 'SQL',
'dsn' => 'mysql://wikiuser:@localhost/phpwiki',
but when I try the index.php appears that error:
c:\archivos de programa\apache group\apache\htdocs\wiki\lib\WikiDB\backend\PearDB.php:698: 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: 'wikiuser@localhost' to database 'phpwiki'])
but I can access to the phpwiki DB using that login from console:
mysql -u wikiuser -D phpwiki
with no problems but phpwiki dont work.
Any idea? I'm little desperated...
thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Me again. I had found the solution. The problem was that the defined user on installation guide has not enought rights, I have changed the wikiuser and gived all posible privileges and now it works.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using Apache 1.3 under WinXP with PHP 4.3.4 and MySQL 4.0.
I have created the DB called 'phpwiki' and the 'wikiuser' user with rights to that DB using the mysql schema.
As I see all the httpd, php and DB is right. I have configured index.php with SQL database:
'dbtype' => 'SQL',
'dsn' => 'mysql://wikiuser:@localhost/phpwiki',
but when I try the index.php appears that error:
c:\archivos de programa\apache group\apache\htdocs\wiki\lib\WikiDB\backend\PearDB.php:698: 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: 'wikiuser@localhost' to database 'phpwiki'])
but I can access to the phpwiki DB using that login from console:
mysql -u wikiuser -D phpwiki
with no problems but phpwiki dont work.
Any idea? I'm little desperated...
thanks.
Me again. I had found the solution. The problem was that the defined user on installation guide has not enought rights, I have changed the wikiuser and gived all posible privileges and now it works.