MYSQL Errors

[justashleenet]

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.

[Tranz]

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.

[justashleenet]

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)

[kegobeer]

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.

[justashleenet]

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.

[kegobeer]

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.

[justashleenet]

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.