it says this when i enter it
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHAR
ACTER SET utf8 COLLATE utf8_bin NOT NULL;
ERROR 1146 (42S02): Table 'account.account' doesn't exist
mysql>
mysql> insert into account.account (name,password,reg_date) values ('test','53b6
320eb06e2c62888a6d1739cd24bd',now());
ERROR 1146 (42S02): Table 'account.account' doesn't exist
mysql>
mysql> CREATE USER 'ODBC'@'localhost';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ODBC'@'localhost'
mysql>
mysql> grant all on account.* to 'ODBC'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> grant all on account.* to 'ODBC'@'localhost';
Can anyone tell me or give me the proper way to do it
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHAR
ACTER SET utf8 COLLATE utf8_bin NOT NULL;
ERROR 1146 (42S02): Table 'account.account' doesn't exist
mysql>
mysql> insert into account.account (name,password,reg_date) values ('test','53b6
320eb06e2c62888a6d1739cd24bd',now());
ERROR 1146 (42S02): Table 'account.account' doesn't exist
mysql>
mysql> CREATE USER 'ODBC'@'localhost';
ERROR 1396 (HY000): Operation CREATE USER failed for 'ODBC'@'localhost'
mysql>
mysql> grant all on account.* to 'ODBC'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> grant all on account.* to 'ODBC'@'localhost';
Can anyone tell me or give me the proper way to do it