DBI->connect fails

Milti has asked for the wisdom of the Perl Monks concerning the following question:

This error returns when Perl script attempts to connect to a known mysql database"DBI connect('membersdb','memeber',...) failed: Access denied for user 'memeber'@'localhost' (using password: YES) at". Why is this happening when 'ALL PRIVILEGES' on the database have been granted to 'member'@'localhost'. The connection can only be made if I use "root' 'root password'. Here is the statement GRANT ALL PRIVILEGES ON `membersdb`.* TO 'member'@'localhost'. What am I missing?

Comment on DBI->connect fails

Replies are listed 'Best First'.
Re: DBI->connect fails by choroba (Cardinal) on Jun 19, 2024 at 19:19 UTC
Can you connect to the database as the user "memeber" without Perl? `map{substr$_->[0],$_->[1]\|\|0,1}[\\|\|{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^ARGV,3]`	[reply] [d/l]
Re: DBI->connect fails by marto (Cardinal) on Jun 19, 2024 at 20:03 UTC
"What am I missing? Advice given the last time this happened.	[reply]
Re: DBI->connect fails by Danny (Chaplain) on Jun 19, 2024 at 19:27 UTC
This may just be a typo in your post but it reads 'memeber' not 'member'	[reply]
Re: DBI->connect fails by ikegami (Patriarch) on Jun 20, 2024 at 01:21 UTC
Your error message and your code don't match. Please post the actual code and the actual error message.	[reply]