Hello, my code is as follow, I didn't add ip address following user 'root'.However I always get error "#28000Access denied for user 'root'@'116.228.89.198' (using password: YES) at test.pl line 8."
How can I get rid of ip address and only use root as login user?
use Net::MySQL;
print "Hello World!\n";
$|=1;
my $mysql = Net::MySQL->new(
unixsocket => $path_to_socket,
hostname => 'a.b.c.d',
database => 'mysql',
user => 'root',
password => "jsief",
debug => 0,
port => '11008',
);
F:>perl test.pl
Hello World!
28000Access denied for user 'root'@'116.228.89.198' (using password: YES) at test.pl line 8.
F:>