Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

DBI->connect fails

by Milti (Beadle)
on Jun 19, 2024 at 19:13 UTC ( [id://11160116]=perlquestion: print w/replies, xml ) Need Help??

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?

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]
Re: DBI->connect fails
by marto (Cardinal) on Jun 19, 2024 at 20:03 UTC
Re: DBI->connect fails
by Danny (Friar) on Jun 19, 2024 at 19:27 UTC
    This may just be a typo in your post but it reads 'memeber' not 'member'
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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://11160116]
Approved by Corion
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others cooling their heels in the Monastery: (3)
As of 2024-07-18 04:26 GMT
Find Nodes?
    Voting Booth?

    No recent polls found

    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.