Quote:
Originally Posted by Djago160
[EDIT]
i have done everything uptill this point insert in mysql command line
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';
the problem is i don't think wamp has one or else i can't find it...
|
Look to the system tray. For me it's the first icon.

So you left click on it, and then select :
And copy+paste the lines to there.
Will set password to 'test' to the database!!!
Quote:
|
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');
|
Changes the character set for those tables/columns.
Quote:
|
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
|
Will insert user 'test' with password 'test' to the game.
Quote:
|
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
|
You don't have to do it, but you may. Easier way is to just create another account ODBC
Quote:
|
grant all on account.* to 'ODBC'@'localhost';
|
Quote:
|
grant all on my.* to 'ODBC'@'localhost';
|