Problem with the PDO connect on rare hosting

[KaMeKuN]

Hi, im having problem to install PW;  "The server requested authentication method unknown to the client ", i can connect normaly with php conection.

$link = mysql_connect('moretrealestatecom.fatcowmysql.com', 'db', 'pass');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db('db');

 
But if i try with PDO return SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client:
 

$dsn = 'mysql:host=moretrealestatecom.fatcowmysql.com;dbname=db';
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
); 

try {
    $online_dbh = new PDO($dsn, 'morelstatedb', 'pass', $options);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Congratulations!";
} catch (PDOException $e) {
    echo $e->getMessage();
} 

[Mike Rockett]

Perhaps this could point you in the right direction?

What version of PHP/MySQL are you running?

[KaMeKuN]

Hi, im having problem to install PW;  "The server requested authentication method unknown to the client ", i can connect normaly with php conection.

$link = mysql_connect('moretrealestatecom.fatcowmysql.com', 'db', 'pass');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db('db');

But if i try with PDO return SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client:

$dsn = 'mysql:host=moretrealestatecom.fatcowmysql.com;dbname=db';
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
); 

try {
    $online_dbh = new PDO($dsn, 'morelstatedb', 'pass', $options);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Congratulations!";
} catch (PDOException $e) {
    echo $e->getMessage();
} 

Thanks for your response; i have all requeriment of PW Green.

PHP version 5.5.6

•  
• PDO (mysql) database
• Filter functions (filter_var)
• MySQLi (not required by core, but may be required by some 3rd party modules)
• GD 2.0 or newer
• JSON support
• PCRE support
• CTYPE support
• ICONV support
• SESSION support
• HASH support
• SPL support
• Found Apache module (cgi): mod_rewrite
• ZipArchive support
• /site/assets/ is writable
• /site/modules/ is writable
• /site/config.php is writable
• .htaccess looks good

[KaMeKuN]

Thanks for u repply; the link give me the idea to downgrade my php version to 5.3 and works like a charm.

Really Thanks.

Regards.-

[Mike Rockett]

You're welcome