JurgenFeuchter

@gagan Deep Singh

Just wanted to inform you that updating the password via SSH work wonders ?? Thanks so much for your support and advice ??

@gagan Deep Singh
I tried that already but it didnt work. Oh well D: either way thanks a bunch for your time. Ill see if I can watch a tutorial or something on SSH connection to try what you said.

I still think it has something to do with the compatibility between the password generated by the MySQL4.1+ and the php5.4. Most likely the hashing is different so the PHP5.4 does not work. Dunno its really weird and I have so long with this problem D: Ill Keep looking. Thanks again Gagan ??

By the way thanks so much for sticking with me and helping me ??

I dont have that much expertise in SSH so Im afraid I cant D: sorry. But what the MySQL database wizard does when creating or setting a password is the same as what the query in the solution you gave me does or not ?

IS there a way to make that but over the mysql database wizard? Cause the server wont allow me to change the password from the SQL Query page. Says my user does not have access D: Ive already tried just updating the password for the user from the wizard, but that wont fix the problem D:
EDIT:
Also tried creating a new user and adding it to the Database, but that wont help either D:

Here is the LOG.

[01-Jul-2015 16:47:56 UTC] PHP Warning:  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 in /home/hfeuchte/public_html/wp-includes/wp-db.php on line 1142
[01-Jul-2015 16:48:00 UTC] PHP Warning:  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 in /home/hfeuchte/public_html/wp-includes/wp-db.php on line 1142

Where would I need to put the password for it to rehash? Ive already tried changing the password several time on the Mysql and then on my /wp-config

The WordPage as of right now it has WP-3.6.1, PHP5.2.17 and MYSQL5.1 and it works just fine. The connection to the database and all the plugins work, but when I change the version of the PHP5.2 to 5.4 the connection to the DataBase fails. I have no idea why. The user and password are correct since when using the PHP5.2.17 it does connect to the Database.