Remote connection mysql problems

[darkbob]

I can't connect remotely to mysql. This is the error message I get.

------
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
------

Ok. So I logged in throush SSH and entered mysql CLI with the mysql username I need, and ran the following queries.

SET SESSION old_passwords=FALSE;
SET PASSWORD = PASSWORD('[current password]');

I get Query OK for both. This didn't work also, even though PASSWORD() function is returning the newer hash string (I tested this).

Any help please?

------
P.s. Yes, I am whitelisted and everyhing is set up correctly.

[klachman]

I am also interested in the answer to this question.

Though currently i manually add MySQL database updates, in the near future I will be wanting the database on my website to be directly scripted by my own local database doing daily updates.

I am not fuilly aware of the limits of our 'jailshells' but it would be a certain flaw if we could not remotely maintain our databases, even if through indirect routines (such as cron parsing FTP uploads).

[quietFinn]

Originally Posted by klachman

I am not fuilly aware of the limits of our 'jailshells' but it would be a certain flaw if we could not remotely maintain our databases, even if through indirect routines (such as cron parsing FTP uploads).

A client in your computer connects to the mySQL server, listening in port 3306, and that has nothing to do with "jailshells", or any shells.