Wednesday, August 13, 2014

Privileges error while accessing DB through PERL script

Error occurred though PERL script while accessing MySQL database.

Error : 
DBI connect('database=DB_NAME','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at a.pl line 16

Solution : 
grant all privileges on DB_NAME.* to 'root'@'localhost' identified by '';

No comments:

Post a Comment