Error:
DBI connect('database :','username',...) failed: Access denied for user 'username'@'localhost' (using password: YES) at
COMPLETE_PATH_PROGRAM.pm line 41
couldn't connect to database: Access denied for user 'username'@'localhost' (using password: YES) at
COMPLETE_PATH_PROGRAM.pm line 41..
Explanation:
This error occurred because password provided to MySql by perl was containing special characters ..like '@' with in double quotes (which looked like password ="@ll3" ) any special char mentioned inside in double quotes is converted to its original. so I changed it to password ='@ll3' to resolve the issue.
any string inside " " looks for phrase match.
any string inside ' ' looks for exact match.
DBI connect('database :','username',...) failed: Access denied for user 'username'@'localhost' (using password: YES) at
COMPLETE_PATH_PROGRAM.pm line 41
couldn't connect to database: Access denied for user 'username'@'localhost' (using password: YES) at
COMPLETE_PATH_PROGRAM.pm line 41..
Explanation:
This error occurred because password provided to MySql by perl was containing special characters ..like '@' with in double quotes (which looked like password ="@ll3" ) any special char mentioned inside in double quotes is converted to its original. so I changed it to password ='@ll3' to resolve the issue.
any string inside " " looks for phrase match.
any string inside ' ' looks for exact match.
Comments