I have installed the prerequisites for SuiteCRM-7.8.7LTS and am trying to get past the main database configuration screen.
I have installed PhPMyadmin and I can see the databases there, however SuiteCRM is not created yet?
I get this message when I select [color=#ff0000][NEXT][/color]
[color=#ff0000]The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password[/color]
When I ran the installer in the browser my link is http://166.xx.xxxx.xx/suitecrm/install.php
Database Name is: SuiteCRM
Host: I used the ipaddress from the link above
Password: the same password I have for PhPMyAdmin
SuiteCRM Database User: Please explain what should be used here.
Any assistance is appreciated.
Is the database on the same host as your CRM?
Sorry, I really should have given more information.
The database is on the same server as the SuiteCRM application. The server is hosted on RackSpace in the cloud.
Rather than trying the IP,if it is on the same host - using ’ localhost ’ may work for you?
Many thanks Camo,
localhost was close, but mot enough; I went to 127.0.0.1 and the install is running.
Many thanks again.
There was a discussion in GitHub a few months ago that explained that there is a significant performance difference between “localhost” and “127.0.0.1”, because although they specify the same computer, they cause different mechanisms to be used when connecting to MySQL.
So it seems that if you can resolve your issue but keep the setting on “localhost”, you would have a performance benefit. On the other hand, this might lead you in the right direction to really understand your problem.