I'm upgrading to the newest version and trying to locate config.php but no luck. Where I can find it?

Because of security concerns we have change some file names around. The configuration file is now known as zenphoto.cfg. The working copy is found in the zp-data folder, the "source" in the zp-core folder.

Since i lost my ZP admin password I deleted "Administrators" table in MySQL. I was prompt to insert DB info. I did but got "Access denied for user 'xxxxxxxx'@'localhost' (using password: NO). To make sure I'm entering right password I created a new db user and password but got the same error message. When i check the config file in zp-data all is written there but no access to db. Please help me to resolve this.

This message is coming straight from MySQL. If it says access denied then the user/password you supplied is not being granted access by MySQL.

The "using password: NO" bit is interesting. That seems to say you did not supply a password.

Hello: as this post is only 1 month old, I decided to use it rather than opening a new one.

Upgrading from 1.2.9. Tried to upgrade both to 1.3 and 1.4. Replicated upgrade situation in 2 shared servers and different domains and folder.

Always get the:
¡Error! Access denied for user (root user) @ (using password: NO)

Databases were always created prior to update, and authentication data verified by developer and by host.

Looks like 1.2.9 Zenphoto is trying to access the database with the root credentials used in the default installation in a local server /etc/phpmyadmin/config.inc.php:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

I only say “looks like” as it is the same behavior, but can´t assure this is the problem.

Please advice.

Thanks

Well, just enter the correct MySQL credentials for your database. "root" is almost never the user name for a live mysql server.

Hello acrylian; the fact is I enter the correct dbase credentials, but the script seems to try to authenticate using the default installation credentials as in:

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

When it should be using these:

$cfg['Servers'][$i]['auth-type']='config';
$cfg['Servers'][$i]['user']='usuario_mysql';

Any ideas?

Thanks

I have no idea where these variables come from. Those are not in the Zenphoto config file. That uses variables that look like $conf['mysql_user'].

They are located in /etc/phpmyadmin/config.inc.php

The issue looks like (and I say only looks like) like a misconfiguration on the 1.2.9 script which for some reason tries to authenticate as user: root and password: " " (none).

Hostings (2 of them) said they can do nothing on their side, as the rest of the script connect fine; this is the one trying to connect with wrong credentials.

Please further advice.

Thanks.

That config file is of phpmyadmin which is a tool to access a MySQL database directly and has nothing to do with Zenphoto.

The files of a Zenphoto installation you find listed here:
http://www.zenphoto.org/news/installation-and-upgrading#4