MySQL problem

[Jacques]

Need some help as I am very hot and still hungover and my brain is not functioning.

I'm installing Vanilla (a forum, and please no suggestions of why don't you use phpBB, SMF etc. I am using Vanilla and your suggestion will not help me) and I am getting the following error when setting up the MySQL Server, Database Name, User and Password.

"We couldn't connect to the server you provided (localhost). The database responded with the following message: Access denied for user '******'@'localhost' (using password: YES)"

The server is 'localhost' as I have other MySQL databases running. The user is created but not the database. I have tried auto an manual install but always get the same error.

It must be something stupid I'm missing.

Any ideas?

[Porn crackers]

Oooooooer....

Have you tried Jacq.....!happy!

PC

[Jacques]

Yeah! Just got an answer from him too 'root' privileges.......

[Cenobitez]

Yeah its down to privilages you need to allow that user certain rights to certain databases, if your using MyAdmin then its easy, if your going to do RAW SQL its a little more tricky but not too bad

[Jacques]

Yeah - just caught me as a bit odd. I have set up other databases for the same user and not had to set any special privileges to create it, wondere if my hosts have tweaked something?

Sorted now anyway but thanks for the reply.

[Cenobitez]

Jacques

I usually find this error when it comes down to the ALL priv which includes creating and erasing tables, and columns which most scripts dont need, but often auto installers do need.

Really you should see if you can remove the above priviliges once its all up and running coz if some cock manages to hit you with SQL Injection of something like DELETE * WHERE * or something worse, you whole DB maybe killed.

[Jacques]

Thanks - will do so now !thumbsup!