Need help with this part for server.

For$aken88 · 04/03/2008, 09:21

im a bit confused with what i gotta do with this bit can someone help me?

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';

For$aken88 · 04/03/2008, 17:32

i will give thanks to everyone who helps

crueby · 04/04/2008, 05:23

lol i cant help but good luck and if you find the answer i would appriciate it if you could PM me the answer

mihatud03 · 04/04/2008, 09:30

start > all programs > mysql > command line
type test or whatever your password was at installation, press enter and the paste that thingy

For$aken88 · 04/04/2008, 17:01

Quote:

Originally Posted by mihatud03

start > all programs > mysql > command line
type test or whatever your password was at installation, press enter and the paste that thingy

thats where i get the error it says cant find match in user table

mihatud03 · 04/04/2008, 18:26

did you put the database files properly?

For$aken88 · 04/08/2008, 23:58

yes