+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Database Error (/showthread.php?tid=32529)
Database Error - El Forum - 07-26-2010
[eluser]Sanity11[/eluser]
Hi,
I can't connect to the database. These settings do work with the MySQL query browser? This is what I get. Can anyone help me please?
Unable to connect to your database server using the provided settings.
Code:
$active_group = "default";
$active_record = TRUE;
$db['default']['hostname'] = "94.236.49.251";
$db['default']['username'] = "APSBB";
$db['default']['password'] = "******";
$db['default']['database'] = "taalquiz";
$db['default']['dbdriver'] = "mysql";
$db['default']['port'] = "3306";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";I have also tried to set pconnect to false, but it makes no difference.
Database Error - El Forum - 07-26-2010
[eluser]pickupman[/eluser]
Have you tried via standard php mysql syntax? Sometimes you might be able to diagnose a connection with a mysql_connect(); Sometimes it can be a firewall issue, where a particular port is blocked. MySQL browser may have firewall exception, but php does not.
Database Error - El Forum - 07-26-2010
[eluser]Sanity11[/eluser]
Thanks for the hint, I tried that, and it comes up with Can't connect to MySQL server on '94.236.49.251' (4) . I will ask the system administrator if the firewall is set up correctly.
Database Error - El Forum - 07-28-2010
[eluser]InsiteFX[/eluser]
Usally the hostname is localhost even on a live website!
InsiteFX
Database Error - El Forum - 07-28-2010
[eluser]pickupman[/eluser]
[quote author="InsiteFX" date="1280339223"]Usally the hostname is localhost even on a live website!
InsiteFX[/quote]
Nope, Godaddy runs a completely different server for MySQL. You have to wait for it to provisioned each time you create a new db. Most cPanel accounts will be localhost, but I have worked on several other hosts, where it's a different hostname.
Database Error - El Forum - 07-28-2010
[eluser]Sanity11[/eluser]
Hi InsiteFX,
I know, however I have worked with databases that use different hostnames many times. This however, is the first time I have received an ip adres for a hostname.