Here I Got Problem when i want to connect with A remote database.
My full working progress is step by step declared below:
-
I have a database located in a host:203.190.10.85:3306 and its a linux server path:/var/lib/mysql/mysql.sock
-
And I wanted to connect it from another host:203.190.10.131 using a Yii->CDbConnection class
-
I give permission from the Mysql DATABASE ENGINE in that database which i want to access from 203.190.10.131
-
the permission is any host
-
but the problem is giving that
Note:
its already successfully connected with core function of mysql
such as:
mysql_connect(‘203.190.10.85:3306/var/lib/mysql/mysql.sock’,‘user’,‘password’ );
and return data that i want
but also try with PDO
the same problem is giving that is giving in Yii CDbConnection
[size="4"]my syntax writing of Yii:[/size]
$dsn=‘mysql:host=203.190.10.85:3306//var/lib/mysql/mysql.sock;port:3306;dbname=mydb’;
$user=‘user’;
$pass=‘password’;
$con=new CDbConnection($dsn,$user,$pass);
$con->active=true;
but its giving error this:
[size=“7”]SQLSTATE[28000] [1045] Access denied for user ‘author’@‘localhost’ (using password: YES) [/size]