SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test'); 
   
  ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; 
   
  insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now()); 
   
  grant all on account.* to 'ODBC'@'localhost'; 
   
  grant all on my.* to 'ODBC'@'localhost'; 

Enter password: **** 
  Welcome to the MySQL monitor.  Commands end with ; or \g. 
  Your MySQL connection id is 60 to server version: 5.0.24a-community-nt-log 
   
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 
   
  mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test'); 
  Query OK, 0 rows affected (0.00 sec) 
   
  mysql> 
  mysql> ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHAR 
  ACTER SET utf8 COLLATE utf8_bin NOT NULL; 
  ERROR 1067 (42000): Invalid default value for 'netbar_ip' 
  mysql> 
  mysql> insert into account.account (name,password,reg_date) values ('test','53b6 
  320eb06e2c62888a6d1739cd24bd',now()); 
  ERROR 1062 (23000): Duplicate entry 'test' for key 3 
  mysql> 
  mysql> grant all on account.* to 'ODBC'@'localhost'; 
  ERROR 1133 (42000): Can't find any matching row in the user table 
  mysql> 
  mysql> grant all on my.* to 'ODBC'@'localhost'; 
  ERROR 1133 (42000): Can't find any matching row in the user table 
  mysql>