goto the bin folder in your mysql.. then doubleclick mysql.exe
goto the bin folder in your mysql.. then doubleclick mysql.exe
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());
create user 'ODBC'@'localhost';
grant all on account.* to 'ODBC'@'localhost';
grant all on my.* to 'ODBC'@'localhost';
this doesn't work...
error in sql syntax...
i hate mysql 4.0
SET PASSWORD FOR 'root'@'localhost' ='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());
i thought that was important...
[EDIT] still not working... sam error list of errors"
SET PASSWORD FOR 'root'@'localhost' ='test';
gives error 1044 acces denied
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE
works
utf8_bin NOT NULL;
error 1064 error in sql syntax
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
error 1044 acces denied
so do yuo have a solution for that?
I'm guessing this doesnt work with Navicat :[
mine navicat gives a error...acces denied...
i don't have acces to mine own server always getting acces denied...
Well the cq_action the new one is lovely works fine only prob is castle building still in chinese lol and can any 1 c the dragon portal all i got is a lil building and i click on it and it says i got pay wat eva to create castle lol
but in pics ive seen there shud be a dragon potral??
There should be 2 little buildings and a Double Dragon portal yes <,~
lol no theres not but mite be because i have client version 1083 but my mates using 1091 and he only c 2 lil buildings no dragon portal
Hey all i got a suspcion my server is not running off mysql4.0 because i have wamp server have i cnt acctuly addon the mysql4.0 install so i maunly put folder there and all that but mysql.exe works fine cud some plz tell me wat else i cud use than wamp and with a guide on how to install mysql.40 propally thanks!
All of my .exe's keep crashing and giving odd error's. And most of then say some kernal error too.
Last edited by Amandy; 18-01-08 at 01:07 AM.
KK, I know I look like a noob but I'm not on epvpers lol.
Umm Why dont you just make a whole new guide for this release.
So its not so confusing.
Edit: NVM I see, Its on epvpers link. TY
Last edited by lostsolder05; 18-01-08 at 11:24 PM.
yea update the guide that wil help
lol thank u! Can some one plz post up a guide on how to instal mysql4.0 plz i cnt get it work fort i had but had'nt lol
yes plz post some guide for setup mysql 4 and connect to database
almost done setting up i just get an error with this:
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test'); <enter>
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; <enter>
Last edited by Django0; 19-01-08 at 10:48 AM.
Working fine for me :) But thats becaus i can read :D (no offence) ^^ just telling you guys that you only need to read :) got same problem as u did.. but i deleted everything and then i realized that i dident need to do that, cos i missed 1 step -.- So read and read :) it will works
Every time i try to login shows invalid user/pass even if i create new accounts its having problem connecting to database or something i think.
Anyone else having problems with their EQ (inventory and warehouse) getting wiped? I havn't tried anything yet (still testing other things) to fix it. I do have an error for the account server about a db log or something, but that shouldn't effect the EQ should it? I will update this post if/when I fix it.
EDIT: Nevermind, I'm not really sure what I did to mess this all up. I think I emptied the wrong table XD Anyway I just added the "my" database again over again (after trying many things) and it all worked. XD
Last edited by Sexi; 21-01-08 at 10:39 PM.
This version is newer than the fixed link at the root of Eudemons forum? Anyone can upload the database in other host please?
Tks.
i need
myserver.rar
can someone mirror it for me? i cant get it from rapidshare
Is this why the EXP thing is bugging out and making characters level fast?