Erroe When Migration To Another Server

kapous · April 27, 2014, 7:33am

Hello All,

Could anyone help me in that?

I was using Yii to build my website which use database on server 67.23.247.28…

I moved my website to another server in different hosting company but when i tried to access database i got this error

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2013] Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111

this is my connection settings in the main.php file

‘db’=>array(

    'connectionString' =&gt; 'mysql:host=67.23.247.28;dbname=postrecc_postrec',


    'emulatePrepare' =&gt; true,


        'username' =&gt; 'username',


        'password' =&gt; 'password',


    'charset' =&gt; 'utf8',


	),

mdomba · April 28, 2014, 8:15am

First step would be to check with the database server administrators if they allow connections from your new server.

kapous · April 28, 2014, 10:18am

Thank you very much …

I checked and they are preventing remote access to DB server …

I think i have to create DB on the new server