PDA

View Full Version : MySQL Permissions error, Help


N_Jay
01-23-2004, 09:54 PM
I have just moved my test installation from one server to another.
The original was running Linux, and the new is running Windows (Apache/PHP/MySQL).
After moving the files, I created a new database with the same name, and created a user with the same user name and password.
I made the minor IP and DIR changes to the config files.

And this is what I get;

Warning: mysql_connect(): Access denied for user: 'apache@localhost' (Using password: YES) in G:\Apache2\htdocs\forums\admin\db_mysql.php on line 40

Now apache is the database user name (I know this works because I used the same name and password with a virgin installation on the Windows box).

I have recreated the password and even the whole user several times, even reloading a fresh copy of the transfered database. (the password is simple to keep typos from being an issue)

WTF am I doing wrong?????

g-force2k2
01-23-2004, 09:58 PM
Did you edit OR re-edit the admincp/config.php?

Regards,
g-force2k2

N_Jay
01-23-2004, 11:19 PM
Did you edit OR re-edit the admincp/config.php?

Regards,
g-force2k2

You mean /forums/admin/config.php

No need to edit, and the database name (forum_3), server name (localhost), user name (apache), and User Password all stay the same.

N_Jay
01-23-2004, 11:56 PM
Stupid me, and Stupid Windows.

In all the changes I made a typo.
BUT, the first failure was caused by WINDOWS calling the PHP user @'computer_name' instead of @localhost (UGH!)

So, I set the user apache to "anyhost" instead of "localhost" and all is well. . . . . . . . ALLMOST!!!!!!!!!!! Ugh!

Now Forums work, vB Admin CP works, vBP admin cp works, user CP works, BUT . . .

Most vBP pages cause;

Fatal error: Cannot redeclare advblocks() (previously declared in G:\apache2\htdocs\includes\advblocks.php:5) in G:\apache2\htdocs\includes\advblocks.php on line 5

But thats a discussion fro the vBPortal group.