installation problem "Access denied for user..."

Searcher78

At the installation i get following errormessage...

(ok)PHP version 4.1.0 or greater
(ok)PHP GD support
(ok)PHP mySQL support
(ok)zp-config.php file
(ok)mySQL setup in zp-config.php
(ok)connect to MySQL
(ok)MySQL version 3.2.3 or greater
(ok)connect to the database db1019932-zp
(ok).htaccess file (RewriteEngine is ON)
(ok).htaccess RewriteBase
(ok)albums folder
(ok)cache folder

DB Error, could not list tables MySQL Error: Access denied for user 'dbu1019932'@'localhost' to database 'db1019932'

db-settings are copied from wordpress(working)...

Who can help me?

Sorry for my poor english :-(

sbillard

setup is trying to do a SHOW TABLES FROM query that apparently is not being allowed. The interesting thing about the print-out above is the database names. In the check the database seems to be db1019932-zp but the query only shows db1019932 with out the -zp suffix.

Is it possible for you to name the database without the "-"? also, are you using a database prefix?

Searcher78

Hello,

no, it is not possible to create a database without the "-" :-(. I tried the DB-prefixes "_zp", "_zen" and without a prefix. Wordpress use the db "db1019932-wp" with the prefix "_wp".

sbillard

Interesting. I cannot create a database with a '-' in the name. The message I get is `Database names must be 2-32 characters in length. Database names must consist of lowercase letters, numbers, and underscores with at least one non-numeric character.` when I try.

Anyway, I think that character is the cause of the problem. I also do not know of a way to fix setup so that it can do the query.

Searcher78

Hi,

after the chance, the errormessage is now:

DB Error, could not list tables MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''db1019932-zp' LIKE '%'' at line 1

sbillard

Yes, can't put the quotes around the db name. So, with a '-' in the name we can't query the table names.

Searcher78

Oh..

thank you for trying to help me... :-)

sbillard

I think you can delete the lines
` $sql = "SHOW TABLES FROM ".$_zp_conf_vars['mysql_database']." LIKE '".$_zp_conf_vars['mysql_prefix']."%';";

$result = mysql_query($sql, $mysql_connection);

if (!$result) {

echo "
DB Error, could not list tablesn";

echo 'MySQL Error: ' . mysql_error();

exit;

}`

and run setup

sbillard

it also looks like you can change the single quote of the first patch to the peckmark (which won't show on this forum since it is the "code" delimiter. On the us keyboard it is the key to the left of the 1 key. kind of a backward single quote. That at least does not give me an error. But since I can't create a DB with a slash, I can't see if it fixes your problem. If it does, let me know.

Searcher78

The tables are now created.

in the admin-menu it shows php-errors:

Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/zp-config.php:90) in /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/auth_zp.php on line 45

Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/zp-config.php:90) in /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/auth_zp.php on line 48

Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/zp-config.php:90) in /is/htdocs/wp1019932_RG0XF7OP7Z/www/zenphoto/zp-core/admin-functions.php on line 48


Now I go to bed... it´s now 4:10 a.m. and at 8 a.m. I have to to attend a lecture. I retry when I´m at home.

Thanks a lot!

sbillard

Will need a list of your zp-config.php file. Something is wrong on line 90.

Searcher78

hey,

yes, line 90 is the Problem. I don´t know how, but there was an "enter", after erasing this line, the problem is fixed. :-)

Thank you very much :-))))

greetings from germany!