[Forum] Stuck on Step 2 & out of ideas!

[Erik Oehler]

I'm using mySQL 5.0.77 and PHP 5.3.3 trying to install vB 4.0.7.

Installing on a web server to connect to a separate DB server.

Stuck on step 2 with error:
Attempting to attach to database

Error description: mysql_pconnect(): Access denied for user 'root'@'(webserver's IP)' (using password: YES) C:\SVN\web\forums\includes\class_core.php on line 313

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.


The root user has full rights to the DB server. I even created a different account w/ full rights and tried it.

I tried switching to mysqli as well, but rec. error:
Error description: mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'webserver's IP' (using password: YES) C:\SVN\web\forums\includes\class_core.php on line 1265

I uninstalled PHP and vB completely, and reinstalled them, and am still stuck at this step. I am officially out of ideas. I thought it might be the password hashing issue (even though my versions are newer), so I've also tried w/ the old passwords.

I used SVN to upload. Could that have negatively impacted this?

Any other ideas would be very welcomed.

[Erik Oehler]

at one point, I would also get the error: Attempting to attach to database

Error description: mysqli_real_connect(): (HY000/2000): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file C:\SVN\web\forums\includes\class_core.php on line 1265

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

After enough combinations of the set password command, that went away and was replaced by the error in the OP.

[Lynne]

Did you create a user to access your database besides user "root"? Did you grant all permissions via the command line or some control panel (which)?

[Erik Oehler]

Thanks for the reply! Yes, I did create another ID as well, and assigned it all permissions via the SQLYog client.

[Lynne]

Your config.php file though seems to be using "root". You should have the other user you created listed in there.

[Erik Oehler]

New user w/ all privileges gets the error:

Attempting to attach to database

Error description: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file C:\SVN\web\forums\includes\class_core.php on line 313

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

I run that command it suggests using the password I set. I also tried running the command SET PASSWORD FOR '(the account name)'@'%' = OLD_PASSWORD('the password I set');

Same error.

If I switch to mysqli, I get:
Error description: mysqli_real_connect(): (HY000/2000): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file C:\SVN\web\forums\includes\class_core.php on line 1265

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

Again, I'm using mySQL 5.0.77 and PHP 5.3.3 so I'm not sure what is going wrong.

[Erik Oehler]

UPDATE: fixed - Despite being on mySQL 5.x, the my.cnf file had the old_passwords field set to 1. Commented it out and I'm good to go!

[Lynne]

Glad you got it fixed.