MySQL related errors
Posted by Naveed Peerzade
Last modified on 14 Dec 2014 02:16 PM (1 Vote)
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:
- Have you created a new db? is it exactly as it shows in your cpanel? eg. xxx_yourdbname where xxx is your host username
- Have you created a new user? is it exactly as it shows in your cpanel?
- 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 "