Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: MySQL syntax error GRANT

by Paladin (Vicar)
on Oct 02, 2018 at 18:54 UTC ( [id://1223421]=note: print w/replies, xml ) Need Help??


in reply to MySQL syntax error GRANT

According to the docs GRANT doesn't have an IDENTIFIED BY clause.

Replies are listed 'Best First'.
Re^2: MySQL syntax error GRANT
by Anonymous Monk on Oct 02, 2018 at 19:04 UTC

    I thought about this, but even:

    my $user = 'somename'; my $db ="test"; my $host="localhost"; $dbh->do(q{GRANT ALL ON ?.* TO ?@?}, {}, $db, $user, $host);

    does not produce any improvement, same syntax error. I am quite perplex.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1223421]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2024-04-19 10:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found