http://www.perlmonks.org?node_id=1223421


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