Hi, after granting privileges did you executed flush privileges command. if not execute below command and then check
mysql> flush privileges; thanks Anil -----Original Message----- From: sam [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 9:09 AM To: mysql@lists.mysql.com Subject: User can't login to his DB. 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]