Holy! i did this like 100s of times
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';
i tried it without
grant all on account.* to 'ODBC'@'localhost';
grant all on my.* to 'ODBC'@'localhost';
and in this thread, in a reply it said add a line, i even did that
all my .ini matches as the above reply. i just changed the server name to test thats all
any idea whats up? and i get this error
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> insert into account.account (name,password,reg_date) values ('test','53b6
320eb06e2c62888a6d1739cd24bd',now());
ERROR 1146 (42S02): Table 'account.account' doesn't exist
mysql> grant all on account.* to 'ODBC'@'localhost';
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> grant all on my.* to 'ODBC'@'localhost';
please help asap