Database connection unsuccessful

[patrickinmotion]

Thanks,

I tried to upload UserSpice to one of my HostGator accounts, and created a blank database like one of your tutorials. I put 127.0.0.1 as the host, and I get unsuccessful. I also tried localhost. Can you tell me what files should get updated, so I can see if they are updated. Maybe the files don't have the correct permissions.


You have to turn on error reporting on your php.ini file.  You set it to E_ALL.  If you scroll down, it's described where to make the change. Some systems have multiple php.ini files, so if you want to make sure you have the right one, create a new php file like test.php

put
<?php 
$ini = php_ini_loaded_file();
echo $ini;


Then run that file and it will give you the path of the file to edit. 

Regarding the inability to access the db. That's a little weird if you can use it from an application.

A few things.  If you use a random IP address on mysql workbench, try putting 127.0.0.1 for your ip.  If you already had 127.0.0.1, try putting localhost or the actual IP of the server.  

Let me know if you need more things to try.