Hi list,
I use the following commands to create a user hubert access to his DB only, but got the following error:
# perl view.pl
DBI connect('datacube','hubert',...) failed: Access denied for user 'hubert'@'localhost' (using password: YES) at view.pl line 8
Unable to connect: Access denied for user 'hubert'@'localhost' (using password: YES)
SQL Grant commands: GRANT SHOW DATABASES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; GRANT SHOW DATABASES ON *.* TO hubert@'10.%' IDENTIFIED BY 'password'; GRANT ALL ON hubertsdb.* TO hubert;
Perl DBI commands:
$database = "datacube";
$username = "hubert";
$pw = "password";
$dbh = DBI->connect("DBI:mysql:$database",$username,$pw);
die "Unable to connect: $DBI::errstr\n" unless (defined $dbh);What is wrong with this error and how to fix it?
Thanks Sam
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
