coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: justashleenet on November 28, 2004, 06:57:31 AM

Title: MYSQL Errors
Post by: justashleenet on November 28, 2004, 06:57:31 AM
I've CHMODed everything. I got everything set to the install portion where I get this error. I tried creating databases for it. Then, I thought maybe the install wizard creates it for you but that didn't work either.


Error:
Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'nicole@localhost' (Using password: YES)


--------------------------------------------------------------------------------

The installer can not find the 'c:/Documents and Settings/Nicole Fierro/My Downloads/ImageMagick-6.1.5-7/' directory you have specified for ImageMagick or it does not have permission to access it. Check that your typing is correct and that you have access to the specified directory.
Title: Re: MYSQL Errors
Post by: Tranz on November 28, 2004, 07:12:56 AM
You would need to create the database and user with password manually. The user also needs to be added to the database to gave the access permissions to it.
Title: Re: MYSQL Errors
Post by: justashleenet on November 28, 2004, 05:35:32 PM
Ok, I went in and created a database and user manually. I set the user to have all priveledges for the database. Then, I went back to the install wizard and I got this error message:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'nicole@localhost' (Using password: YES)
Title: Re: MYSQL Errors
Post by: kegobeer on November 28, 2004, 07:51:41 PM
Make sure the database server, database name, database user, and database password are all correct.  If a connection can't be made, one or more of them may be incorrect.
Title: Re: MYSQL Errors
Post by: justashleenet on November 29, 2004, 01:29:38 AM
I double checked my requirements to see if this could be the problem but everything checked out ok.

The database server is localhost which is the one I have set up for the database. I created a new username and password and tried that and set it to the database with all priveledges. I am positive this is correct. The database name is also correct. I have no idea what I am doing wrong. :(

I am a noobie to Coppermine and have only set it up through Fantastico, which I don't have on my new hosting plan, so I don't know what I've done to make this now work out.
Title: Re: MYSQL Errors
Post by: kegobeer on November 29, 2004, 01:49:07 AM
Does your host have some sort of FAQ or guide to accessing your MySQL database from a php script?  Some hosts put a prefix in front of the username automatically.  Instead of nicole, you may have to use yourwebsite_nicole, where yourwebsite would be whatever name you have the account under.

I'd ask your host for the exact mysql login you have to use.
Title: Re: MYSQL Errors
Post by: justashleenet on November 29, 2004, 03:05:42 AM
Yes, I do have that. I asked them before I tried to install coppermine what it would be it is unbrella_ and I made sure to have that in there also.