Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: MySQL syntax error GRANT

by Paladin (Vicar)
on Oct 02, 2018 at 18:54 UTC ( #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);

    [download]

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

[reply]
[d/l]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1223421]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (2)
As of 2022-05-25 03:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (84 votes). Check out past polls.
    Notices?