Trying to get gallery to work, having MySQL problems

[Phate]

Hi people,

for those who unsure what I mean gallery is like wordpress. kind of a website already built.

you upload all the files to the server.

go on the website and it takes you through an auto thing where it sets up your website, so you can login from wherever and work on it etc.

Now you also have to create a MySQL database, so right I thought no problem, made the database.

Come to the part in the installer called

"Database Setup"

so I've punched in all the details and I get this error message

"localhost: Access denied for user '<insert username here>' to database 'gallery2"

Now, i've got all the right details, like database name, username, password etc. And retyped them many a time, sometimes 1 letter at a time.

And I still get this sodding error message.

Does anyone have any ideas what to do or any clue what I'm on about?

Many Thanks

 

[daz]

Where you enter database name and database username, try using your hosting username, followed by an underscore and then the name of the database.

So say you have database gallery2 under hosting account phate, refer to the database as phate_gallery2.

Likewise with your database username. If you create a username phate, and your hosting account username is also phate, try phate_phate.

 

[Phate]

So say you have database gallery2 under hosting account phate, refer to the database as phate_gallery2.

Yay!

tried this and it worked my god I could kiss you lol, been annoying me for ages right...i'll post my next problem shortly