SQL Databse issues with Sugar CRM

NetHosted Customer Joined: 30 Mar 2009 Posts: 3

Hi there,

I cannot connect to the SQL database I set up for some reason and I think tis because I have some of the settings wrong.

This is the error message I am getting:

The provided database administrator username and/or password is invalid, and a connection to the database could not be established. Please enter a valid user name and password. (Error: 1045: Access denied for user 'tucloud_Admin'@'saturn.solardns.com' (using password: YES)).

Any advice ? I KNOW the usernames and passwords are all correct and I set the host as my domain name.

I am installing Sugar CRM and it requires the following:

Provide Database Name
Name of the database that will contain the data for the Sugar instance you are about to install:
* Database Name

Name of web server or machine (host) on which the database is located:
* Host Name
Provide Database User Information
The username and password of a database administrator who can create database tables and users and who can write to the database is necessary in order to set up the Sugar database.
* Database Administrator Username
Database Admin Password

For security purposes, you can specify an exclusive database user to connect to the Sugar database. This user must be able to write, update and retrieve data on the Sugar database that will be created for this instance. This user can be the database administrator specified above, or you can provide new or existing database user information.

Sugar Database Username

* Sugar Database Username
Sugar Database User Password
Re-enter Sugar Database User Password

Any help would be appreciated !

NetHosted Staff Joined: 22 Mar 2004 Posts: 7017

Have you added the user you created to the database? This must be done using the MySQL tool in cPanel.

Thanks,

Andrew

NetHosted Customer Joined: 30 Mar 2009 Posts: 3

Yes I have done and it still is not connecting.

I think it maybecause I am using shared hosting.

Godaddy had a long special address for their SQL databases and I am just putting my domain name where it is asking me to put the database host.

Is there a long winded, multi dotted domain name somehwere for these SQL databases ?

NetHosted Staff Joined: 22 Mar 2004 Posts: 7017

Hi,

We go the short route here: localhost

That's all you need to put.

Thanks,

Andrew

NetHosted Customer Joined: 30 Mar 2009 Posts: 3

Ok you didnt say it because you were far too polite but you are right. I am a dumbass.

Worked a treat thank you !

NetHosted Staff Joined: 22 Mar 2004 Posts: 7017

I wouldn't go that far, you're just used to different hosting!

Andrew

Client Support	Community	Server Status	Contact Us	Client Login
Email Hosting	Website Hosting	Reseller Hosting	VPS Hosting	Dedicated Servers