Skip to main content

DBI connection

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.

Comments

Post a Comment

Popular posts from this blog

Backslash on mac

I had been struggling to type back slash ( \) character on mac japanese keyboard as they don't have it printed on the keyboard, and I was doing copy paste all the time from google when i needed to type it until recently a tip came to my rescue , shortcut to backslash on mac japanese keyboard. Alt + ¥  Hope it helps others. 
Post a Comment
Read more

How to Enter Split View on MAC

Enter Split  View Hover your pointer over the full-screen button in the upper-left corner of a  window . Or click and hold the button. Choose ”Tile  Window  to Left of Screen” or ”Tile  Window  to Right of Screen” from the menu. ... Then click a  window  on the other side of the screen to begin using both  windows  side by side. Hover your pointer over the full-screen button in the upper-left corner of a  window . Or click and hold the button. Choose ”Tile  Window  to Left of Screen” or ”Tile  Window  to Right of Screen” from the menu. ... Then click a  window  on the other side of the screen to begin using both  windows  side by side.
Post a Comment
Read more