CDbConnection failed to open the DB connection

Yii 1.1 General Discussion
1

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…

2

your mysql server is still set to "myhost" change that

3

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,

		),
4

yes im use the ip like "95.45.14.25"

but still the error…

5

Sound like PRIVILEGES Issue, if your domain having same is then use ‘LOCALHOST’ instead of IP.

http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server

6

if the ip is not working try "localhost" instead

7

correct…thanks…its working

8

your correct…i changed as "localhost" instead of "95.85.15.12"

thanx for reply…