ZenphotoCMS Forum
Installation Problem > MySQL > Access denied - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Installation Problem > MySQL > Access denied (/thread-10007.html)



Installation Problem > MySQL > Access denied - talwen - 2012-05-22

Hello,

during the installation the following error message appeared:

"Access denied for user 'root'@'localhost' (using password: NO)"

After modifying zenphoto.cfg with the following arguments:

$conf['mysql_user'] = 'myuser'; // Supply your Database user id.
$conf['mysql_pass'] = 'mypass'; // Supply your Database password.
$conf['mysql_host'] = 'localhost'; // Supply the name of your Database server.
$conf['mysql_database'] = 'photo'; // Supply the name of Zenphoto's database

I get another error-message:

"Vielleicht ist ein Problem mit dem Upload aufgetreten. Sie sollten die folgenden Dateien überprüfen: zp-core/zenphoto.cfg"

(problem with upload, pls. check "zp-core/zenphoto.cfg").

I am quite sure that this is neither a MySQL nor PHP-related problem, because other CMS-Systems could be installed and are running without any problems using the same credentials without changing PHP- and MySQL-Parameters.

Any ideas?




Installation Problem > MySQL > Access denied - acrylian - 2012-05-22

Well, the error tells that the MySQL credentials are not correct. Most likely "localhost" is not the name of your database server.




Installation Problem > MySQL > Access denied - talwen - 2012-05-22

Hello,

re:

Well, the error tells that the MySQL credentials are not correc

I agree!

"Most likely "localhost" is not the name of your database server"

Usually it is. Is is different for a zenphoto-installtian?

Best regards

talwen




Installation Problem > MySQL > Access denied - talwen - 2012-05-22

Sorry,

I forgot to mention that this the insttallation is running (or not) on a vhost.

talwen




Installation Problem > MySQL > Access denied - acrylian - 2012-05-22

[i]"Most likely "localhost" is not the name of your database server"
Usually it is. Is is different for a zenphoto-installtian?[/i]
That's a matter of your database server, not of Zenphoto...I know no host where "Localhost" works...that only works on local servers like WAMP, MAMP etc.




Installation Problem > MySQL > Access denied - talwen - 2012-05-22

Another addition:

Whenever any change is made to zenphoto.cfg (aplying the correct credentials for MySQL-access) the setup-program said that I should check if there is problem with zenphoto.cfg and/or if the file is uploaded correctly.

talwen




Installation Problem > MySQL > Access denied - talwen - 2012-05-22

Solved!

After creating the directory zp-data I manually I copied the file zenphoto.cfg into this directory. Then I changed the MySQL-parameters and run the install-routine.

Everything is alright now.

Thank you.

talwen

P.S.: Although I do not know why directory zp-data is not "supplied" within the downloades files and why the zenphoto.cfg is not located accordingly.




Installation Problem > MySQL > Access denied - sbillard - 2012-05-22

Typically that folder is created by setup itself if it is not present. So presumably something prevented setup from doing that. It is not supplied by the package because some FTP clients believe that if they copy an empty folder to a site they should remove everything that existed in the destination folder if it already exists. Not a polite behavior, but one we wish to avoid.

BTW: "localhost" works ONLY if the database application is running on the same host as the web server. That may be the case, but most shared sites do not do so for performance reasons.




Installation Problem > MySQL > Access denied - talwen - 2012-05-22

Hello,

thank you very much.

I am aware that every standard "setup-procedure" has its own problems. FTP-Client too.

I am quite happy that zenphoto is running now. That's all that counts.

Although your remarks could be mentiones in another "readme".

Re:

"BTW: "localhost" works ONLY if the database application is running on the same host as the web server. That may be the case, but most shared sites do not do so for performance reasons."

On my root-server serveral domains are running as vhosts. Most CMSs and other applications are run under a central MySQL-Server under different databases but not database-servers. This is - at least under PLESK - a standard procedure. Might and will be different (?) for a vhosted-server.

However: Thanks a lot

Best regards

talwen