hiii…
in my yii website the mysql connection is working in localhost…
after hosting i got a error like this
CDbConnection failed to open the DB connection: SQLSTATE[00000] [1130] Host ‘MyHost’ is not allowed to connect to this MySQL server
can you give any suggestions…?
thanks…
alirz23
(Ali Raza)
2
your mysql server is still set to "myhost" change that
Use your mysql database server ip…
like this -
'db'=>array(
'connectionString' => 'mysql:host=115.121.XXX.XXX'; dbname=your_db_name',
'emulatePrepare' => true,
'username' => 'db_user_name',
'password' => 'db_password',
'charset' => 'utf8',
'enableProfiling'=>true,
),
yes im use the ip like "95.45.14.25"
but still the error…
alirz23
(Ali Raza)
6
if the ip is not working try "localhost" instead
correct…thanks…its working
your correct…i changed as "localhost" instead of "95.85.15.12"
thanx for reply…