EO server EPIC FAIL

[GameMasterOni]

This is driving me crazy... I have been working on this for 29 hours straight and I KNOW I followed the directions EXACTLY because I started over 7 times... Here's where I get stuck...

Into the console you have to insert some queries.
Code:
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test'); (Works fine)

ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

I have tried...

ALTER TABLE `my`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

And...


ALTER TABLE `my`.`account2` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

No matter what I do it keeps giving me this error...

ERROR 1034 (HY000): Incorrect key file for table 'account'; try to repair it.

If at all possible can I get someone to explain in detail how to use the console... I even tried to skip this part and run the ACCServer and it just crashes.

Please assist, this is driving me insane. (P.S. I'm not trying to have people connect to play with me I just want to play alone.

Thanks in advance... ~Oni

[idlemonkey]

just generate a new password with a register script and paste the hashed results into your account table this will change your password in the game...

however it appears that you are trying to creat a mysql user in which case it is not part of the account table but in the mysql db user table
the easiest way to edit this for someone who doesnt know how is with navicat and you can do this by simply connecting to your db with the root account and selecting users up near the connection tab... if I am mistaken or you need clarication just say