I am trying to set up a database on the server and keep getting the same error message. it say to me that it was successful in connecting to the db but access is denied for the user. what is causing this as the password and user name that is being used has benn used before to connect to the server and create the databases.

Recommended Answers

All 2 Replies

If it was successful in connecting, why would it say access denied ?

Are you using different software to connect to the db?

I have had a case when using a login with read/write access to my db from SQLYog where my ISP login automatically gets added to the db username I entered, and I get the same error. Yet that user works fine from the web. When I change my SQLYog username to a db user with full access, everything goes like clockwork.

I hope this makes sense! ;-)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.