MySQL related errors

Posted by Naveed Peerzade
Last modified on 14 Dec 2014 02:16 PM (1 Vote)

The most common error you will receive is

Error in db: Access denied for user '___'@'_____' (using password: YES)

Please pay close attention as the error says it all "Access denied", that clearly means the details you have entered are wrong

Checklist:

  1. Have you created a new db? is it exactly as it shows in your cpanel? eg. xxx_yourdbname where xxx is your host username
  2. Have you created a new user? is it exactly as it shows in your cpanel?
  3. Have you assigned full privilieges to the same database? because if the user is not assigned to that database that means it doesnt have permission to use it.

Here is a great video tutorial by hostgator

http://www.hostgator.com/tutorials/cpanel/hgx3/creating-a-mysql-database.htm

If everything is okay and if you are still facing problem... the most common problem is:

When you copy paste any text some times it adds extra space. e.g.

"mypassword"

"mypassword "

 

 

(1 Vote)
Helpful
Not helpful

Need Support?

Can't find the answer you're looking for? We're here to help!
Submit Ticket

Copyright © 2011-2024 Instant Product Engine.   All rights reserved.