Error Connection remote db mysql |
Hi all,
I have a problem with db connection on my remote mysql server: Fatal error: Call to a member function real_escape_string() on boolean in/xxx/system/database/drivers/mysqli/mysqli_driver.php on line 391 and Message: mysqli::real_connect(): (HY000/2003): Can't connect to MySQL server on 'xx.xxx.xxx.xxx' (111) Filename: mysqli/mysqli_driver.php Line Number: 202 I try to access with same config parameter on my mysql client gui and i connected successfully. My codeigniter versione is 3.0.4 Thank's Marco.Italy
Try changing the hostname from 'localhost' to '127.0.0.1' and see if that makes a difference.
Hi,
I don't wont to connect on my localhost; my mysql server is on another server. I try connect to server with for example HeidiSQL and work correctly. When i try to connect with the same config with codeigniter fail.
You must make sure that your other server accept remote connections and from what IP's.
Website: http://avenir.ro
|
Welcome Guest, Not a member yet? Register Sign In |