Need help with this part for server.

04/03/2008 09:21 For$aken88#1
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';
04/03/2008 17:32 For$aken88#2
i will give thanks to everyone who helps :D
04/04/2008 05:23 crueby#3
lol i cant help but good luck and if you find the answer i would appriciate it if you could PM me the answer :)
04/04/2008 09:30 mihatud03#4
start > all programs > mysql > command line
type test or whatever your password was at installation, press enter and the paste that thingy :p
04/04/2008 17:01 For$aken88#5
Quote:
Originally Posted by mihatud03 View Post
start > all programs > mysql > command line
type test or whatever your password was at installation, press enter and the paste that thingy :p
thats where i get the error it says cant find match in user table
04/04/2008 18:26 mihatud03#6
did you put the database files properly?
04/08/2008 23:58 For$aken88#7
yes