Bizarre installation issue

[MarkDH]

Hi all

I’m new to SuiteCRM but I’m having trouble installing it. I’ve got it uploaded to my web server and everything without any problem, but unfortunately I’m having problems during actual installation.

I have created a SQL database and a user but I get the error “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” when I put in all the credentials.

Location of SuiteCRM files is public_html/CRM.

For this we’ll say that the database I’ve created through CPanel is called ‘database’ and the user is called ‘user’, and the URL is http://www.website.com/CRM.

So when configuring the database in SuiteCRM installation I’m putting in the following:
Database Name: database
Host Name: localhost
SuiteCRM Database User (dropdown): Provide existing user (does this mean an existing MySQL user on the server?)
SuiteCRM Database User: user
SuiteCRM Database User Password: password

Then under the site configuration I have
SuiteCRM Application Admin Name: user (same as above - does that matter?)
SuiteCRM Admin User Password: password
URL of SuiteCRM Instance: http://www.website.com/CRM

It’s not clear to me whether the database needs to exist already, and whether I must use existing user information or if the install process is going to create all that stuff for me. If that doesn’t matter, what am I doing wrong that’s throwing up the error?

Any help would be hugely appreciated!

Thank you
Mark

[Camo]

Hi,

You are defining the host as localhost, is your sql server on the same server? e.g. if you are using mysql, can you do mysql -u user -p and login to your sql server or do you have to define an external host to access this(from the same host as the crm is hosted)

[MarkDH]

Hi Camo. Thank you for the reply. I’ve now gone with another CRM option as I’m a bit pressed for time.

However, FYI my SQL server is on the same server.