Unable to connect to database

Permalink 1 user found helpful
I've installed concrete5 up to the point where I enter the database info and now I get an "Unable to connect to database" error. The username & password are correct as I can log into the database directly. There are only letters in the username & in the password. According to my provider the MySQL 5 connection settings for PHP should be localhost:/tmp/mysql5.sock or for local web apps localhost | Socket: /tmp/mysql5.sock. I've tried them both (as well as a number of other variations) without success. Any help would be greatly appreciated.

Thanks,
John

 
JohnL replied on at Permalink Reply
Problem solved thanks to "support28" at ICDSoft (my host). I quote:
Concrete5 ... uses a MySQL library that does not accept the MySQL socket when specified as "localhost:/tmp/mysql5.sock", i.e. the MySQL socket needs to be specified in a separate field which, unfortunately, is not present in the installation screen.

To be able to connect to the MySQL 5 database and successfully install the Concrete5 CMS, you should take the following steps:

1. Login to your hosting Control Panel and navigate to the MySQL Databases section there.
2. Make sure that remote connections are enabled for the database and the respective user that you want to use.
3. Then navigate to the installation page of your web application and enter the following in the "Server" field:

mysql5.domain:3307

Hope this helps someone else.
John