Fresh install Database connection fail

[peseotni]

I installed churchcrm fresh on a shared host.
Everything goes well until the database connection, I get the following error message:

Could not connect to MySQL on db409999145.db.1and1.com on port 3306 as dbo409999145. Please check the settings in Include/Config.php.
MySQL Error:

Password and everything else, I checked and are right.
Please advice.

[rbeerster]

If you are using 127.0.0.1 as the database host, please change that to localhost. If that does not correct the issue, use mysql -u Database_User -p from the command line to test and verify the ChurchCRM username and password.

[peseotni]

The database is at 1and1.com and I just copied the datebase name, user and password, but it doesn't connect.

[rbeerster]

If I understand correctly, you need remote network access to the database. You need to review both MySQL permissions and a possible host-based firewall. Did you run mysql_secure_installation and remove remote access? If so, you will need to allow your remote host to access the database.

If the issue is a firewall, you will need to open port 3306 from your remote host. You can debug with nc -vt DateBaseHost 3306 where DateBaseHost is the domain name or IP address of the server running MySQL. This will show whether you can successfully connect or not.

[MrClever]

This problem should be fixed with #4444