Page 1 of 3
Access denied for user 'wwwrun'@'localhost' (using password:
Posted: Sun Mar 09, 2008 1:44 am
by brainray
Hello,
while trying to install phpmyfaq I got the follow error message:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user 'wwwrun'@'localhost' (using password: NO) in /www/htdocs/w009a6b8/faq/inc/PMF_DB/Mysqli.php on line 66
The connection to the database server could not be established.
The error message of the database server:
Access denied for user 'wwwrun'@'localhost' (using password: NO)
It looks like the database was not setup porperly, but it's there. I tried to change things a few times, but now I'm puzzled.
Thanks in advance for any help
Ray
Posted: Sun Mar 09, 2008 9:49 am
by Thorsten
Hi,
did you ran the installation script?
bye
Thorsten
Posted: Sun Mar 09, 2008 11:23 am
by brainray
Hi,
yes I ran the installer script and inserted the database data etc. into the fields. Any ideas?
Many thanks
Ray
Posted: Sun Mar 09, 2008 11:28 am
by Thorsten
Hi,
is everything correct in inc/data.php?
bye
Thorsten
Posted: Sun Mar 09, 2008 11:40 am
by brainray
Hi,
yes, the same data that I entered into the installer script.
Well, I was not 100% sure if the SQL sever host address is correct the way I entered it. Might that have caused the next step to proceed?
Thanks again
Ray
Posted: Sun Mar 09, 2008 11:42 am
by Thorsten
Hi,
is inc/data.php readable for the webserver? The database class uses the default values and that causes your problems.
bye
Thorsten
Posted: Sun Mar 09, 2008 11:54 am
by brainray
Hi,
permissions are 644, so reading should work, right?
Thanks
Ray
Posted: Sun Mar 09, 2008 11:57 am
by Thorsten
Hi,
I think you need 755... the webserver has to execute the PHP files.
bye
Thorsten
Posted: Sun Mar 09, 2008 12:31 pm
by brainray
Hi,
okay, brilliant! I then did an update - I hope it was right.
At the end of the update on step 5 the script says:
Warning: Invalid argument supplied for foreach() in /www/htdocs/w009a6b8/faq/install/update.php on line 1613
The index.php shows a white page. After turning debugging on it says:
Fatal error: Call to a member function fetch_object() on a non-object in /www/htdocs/w009a6b8/faq/inc/PMF_DB/Mysqli.php on line 124
Might that result from wrong database setup? Which is the best way to continue?
Many thanks again for your valued help!
Ray
Posted: Sun Mar 09, 2008 12:38 pm
by Thorsten
Hi,
why did you an update? You don't need one after a fresh installation.
bye
Thorsten
Posted: Sun Mar 09, 2008 12:52 pm
by brainray
Hi,
hmmm, sorry. I think it was the my best guess how to proceed. Should I go for a new installation? I wouldn't matter to do so.
Thanks again
Ray
Posted: Sun Mar 09, 2008 12:53 pm
by Thorsten
Hi,
yes, please try a fresh installation.
bye
Thorsten
Posted: Sun Mar 09, 2008 5:00 pm
by brainray
Hello again,
I did a fresh installation and also got a response from my provider regarding the SQL server host, which is localhost btw :-/
Okay, I also got the same error message while installing, then set the permissions for inc/data.php to 755. Where should I go now? The tables in the database have not yet been created, so I think there must be a way to continue the installation
Thanks again
Ray
Posted: Sun Mar 09, 2008 7:11 pm
by Thorsten
Hi,
please try 777 for inc/data.php during the installation.
bye
Thorsten
Posted: Mon Mar 10, 2008 11:22 am
by brainray
Hi,
I tried 777 for data.php.original before installation. But when I install, the script seems to create a data.php file that has 644 and the installation stops.
How can I continue the installation? If I call the installer script, I get the message
It seems you're already running a version of phpMyFAQ.
Please use the update script.
Since updating is not the right choice, what would be the right one?
Many thanks again
Ray