MYSQL SERVER QUESTION? PLEASE HELP!

[revolution263]

Im following forcers guide to making my own server. I have gottin to the 8th step. I have to put in a few queries in my mysql command line client. The first thing wich is

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');

after I press enter is says query ok..
Then I go to the next step... by putting in

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

then its says..

ERROR 1146 (42S02): Table 'account.account' doesn't exist

It also asks for you to put in

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

But I get the same message after trying those as well.
Can someone please help me, and let me know what I did wrong or have to change.
Thanks...

[Coksnuss]

Well, i dont know a "forcers guide" but the error message give you all informations you need. You do not have a database 'account' or you have one, but it doesnt contain a table with the name 'account'.

AFAIK the users information is stored into the "mysql" database.

Type:
USE mysql;
SHOW COLUMNS FROM user;

This table contains a password field, but its not VARCHAR(32) like in your statement above, its char(41).

[fusionkid]

Originally Posted by Coksnuss

Well, i dont know a "forcers guide" but the error message give you all informations you need. You do not have a database 'account' or you have one, but it doesnt contain a table with the name 'account'.

AFAIK the users information is stored into the "mysql" database.

Type:
USE mysql;
SHOW COLUMNS FROM user;

This table contains a password field, but its not VARCHAR(32) like in your statement above, its char(41).

Wrong lol mysql database is for mysql its self with infomation to run.

But your right about you either don't have a account table or database you got pictures of navicat?

With pictures may be able to help you a bit more.

[revolution263]

Originally Posted by fusionkid

Wrong lol mysql database is for mysql its self with infomation to run.

But your right about you either don't have a account table or database you got pictures of navicat?

With pictures may be able to help you a bit more.

I have the program Navicat. But Im not quite sure how to use it yet. And what do you mean by "do you got pictures of navicat?"

[m2killez]

same but i cant find where the command line is at lol

[fusionkid]

Omg I said if we could have pictures of the errors and the picture of bavicat loaded up so i can see your database duh.

[revolution263]

Well why does it matter if there is a pic.... it will just show you what I told you. It tells me "ERROR 1146 (42S02): Table 'account.account' doesn't exist"
Do you think that forcer meant for me to put my mysql account in the part that says " 'account.account' "?

[fusionkid]

go to mysql and go to data and tell me what folders are in there

[revolution263]

Originally Posted by fusionkid

go to mysql and go to data and tell me what folders are in there

Theres the Eudemons_phdev folder and inside of that is the ACCServer folder, GameServer, Beta File, and data.rar

Then there is a folder a test folder but nothing is in it.

And theres an mysql folder with a bunch of MYI, MYD, and MYI type files in there

And also inside of the data folder there is ANOTHER data folder with a PID file in it.

[fusionkid]

lol go to the mysql dir where u installed mysql and what version r u using and tell me if you see a folders called mysql, account.my in the c:mysql/data