Page 1 of 2

hellp me at Database Information in installation steps

Posted: Thu Mar 19, 2009 7:16 pm
by scripter
hi every one
I won't  to setup CMS Simple made at connect with the database show me this error
Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database.
i create the database and user & password to the database, at Database Information fill the informations by the way

User_Database
User_database user
User_database password
but don't know the database port?

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:23 am
by scripter
when Answer's

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:29 am
by RonnyK
What did you set for db-host, localhost ?


Ronny

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:31 am
by scripter
by default localhost

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:34 am
by alby
scripter wrote: but don't know the database port?
If empty, CMSMS use default port of your DB system (p.e. mysql use 3306)
If you don't set a different port (ex. for many versions of same DB system), leave blank

Alby

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:44 am
by scripter
alby wrote:
scripter wrote: but don't know the database port?
If empty, CMSMS use default port of your DB system (p.e. mysql use 3306)
If you don't set a different port (ex. for many versions of same DB system), leave blank

Alby
thanks for your answer
now try to use 3306 in port and leave it blank but nothings change
it's same error and ican't go to the next step
iwill installed in in localhost server on my PC and work properly but in hosted server show me this error
how can i remedy this error

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:52 am
by alby
scripter wrote: iwill installed in in localhost server on my PC and work properly but in hosted server show me this error
how can i remedy this error
Are you sure of your mysql credentials on server and enables?

Alby

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 11:55 am
by scripter
if you wont send my cpanel information for you by PM

Re: hellp me at Database Information in installation steps

Posted: Fri Mar 20, 2009 12:01 pm
by alby
scripter wrote: if you wont send my cpanel information for you by PM
shoot

Alby

Re: hellp me at Database Information in installation steps

Posted: Sun May 17, 2009 8:56 am
by pythagora
I am having exactly the same problem.  I left the port blank as the default.  I am logged in as the user for the database and still get the error on install.  I have created the database with the correct user and password.  I have listed the correct host.  Now what?

Re: hellp me at Database Information in installation steps

Posted: Sun May 17, 2009 9:55 am
by alby
pythagora wrote: I am having exactly the same problem.  I left the port blank as the default.  I am logged in as the user for the database and still get the error on install.  I have created the database with the correct user and password.  I have listed the correct host.  Now what?
Have you restarted your DB server for new credential?

Alby

Re: hellp me at Database Information in installation steps

Posted: Tue May 19, 2009 4:30 pm
by Pierre M.
Hello all.

Issue submitters, please tell :
-the database engine (confirm it is MySQL)
-the database provider (your hosting provider ? you and your laptop ? else ?)
-the database creation process or the database information given by the database provider.

Without such informations nobody can help you.

Pierre M.

Re: hellp me at Database Information in installation steps

Posted: Sun May 24, 2009 2:52 am
by noncon
OK, I'm having the same issue, I'll try to include all the information.

I'm installing cmsms 1.5.4 and I'm getting an error on step 5 when I click Continue.  The error says: "Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database."

I set the database up on godaddy, it is a mysql database.  On godaddy the database name and the username are the same, I have confirmed them both as well as the password by being able to login to the database just fine via the cpanel at the godaddy site.  As far as the database host address goes, I've used the default of "local host" as well as the one that godaddy lists as "p50mysql282.secureserver.net" and still get the error. 

I thought that the issue might have to do with user privileges but I can't figure out how to view or edit privileges.  Godaddy uses myphpadmin for the database and I just don't see a way to edit the privileges in it.

Not sure what else to do, I've seen that a lot of people have had this error in the past on these forums but unfortunately they either never came back to post the resolution or simply post that the issue was resolved without giving any details.  I promise that if I figure this out I'll post the resolution. 

Please, if anyone has any ideas please post them.  Feel free to ask for any details and I will provide them.  One thing though, although I work as a web developer, this is my first time  installing a cms and databases are definitely not my strong suite so don't assume I will understand database jargon, you might have to talk baby talk to me ;)

Re: hellp me at Database Information in installation steps

Posted: Sun May 24, 2009 9:09 am
by Peciura
To check user database-specific privileges goto your database ("jnn" in the example) and privileges tab look for your user ("jnn" in my case). In my example user jnn has all privilege only in jnn database. Besides pay atention to the location in phpMyAdmin.

Re: hellp me at Database Information in installation steps

Posted: Sun May 24, 2009 6:24 pm
by noncon
here is a screen shot of what I see when I log into the database on godaddy.  Bondcms is the database and as you can see there is no tab for privileges.  Maybe I've done something wrong and this screen shot will give someone an idea.