errors on World and Zone5boot...

[Shawn319]

Most people can close Winmysqladmin completely and still be able to connect (it keeps mysql-nt.exe in Windows Processes).

Re-run winmysqladmin.exe, minimize it then try again.. i will fix the readme.

[Shawn319]

Also, there's a post about 2006 error on the top of this forum.

[ibleet]

Hmmmm....why are we constantly reprinting info from the readme.txt file in these forums? I'm not gonna answer that question because the majority of us already know. /bonk anyone who doesn't use the readme. That is your first line of tech support.

_____________________
Ibleet

[ibleet]

Ok my bad...you are not trying to run without a database, rather the program is having trouble finding a database on your local machine.

[Xalivor]

Everytime i go to the mysql and type use eq it says DB changed, but when i type source db.sql it says this

ERROR 1062: Duplicate entry '2136' for key 1
ERROR 1062: Duplicate entry '2137' for key 1
ERROR 1062: Duplicate entry '2138' for key 1
ERROR 1062: Duplicate entry '2139' for key 1
ERROR 1062: Duplicate entry '2140' for key 1
ERROR 1062: Duplicate entry '2141' for key 1
ERROR 1062: Duplicate entry '2142' for key 1
ERROR 1062: Duplicate entry '2143' for key 1
ERROR 1062: Duplicate entry '2144' for key 1
ERROR 1062: Duplicate entry '2145' for key 1
ERROR 1062: Duplicate entry '2146' for key 1
ERROR 1062: Duplicate entry '2147' for key 1
ERROR 1062: Duplicate entry '2148' for key 1
ERROR 1062: Duplicate entry '2151' for key 1
ERROR 1062: Duplicate entry '2152' for key 1
ERROR 1062: Duplicate entry '2154' for key 1
ERROR 1062: Duplicate entry '2156' for key 1
ERROR 1062: Duplicate entry '2158' for key 1
ERROR 1062: Duplicate entry '2160' for key 1
ERROR 1062: Duplicate entry '2162' for key 1
ERROR 1062: Duplicate entry '2164' for key 1
ERROR 1062: Duplicate entry '2165' for key 1
ERROR 1062: Duplicate entry '2166' for key 1
ERROR 1062: Duplicate entry '2171' for key 1
E
and so on

[Trumpcard]

You already have the database loaded, of course its going to spit out a million duplicate items when you source db.sql.

drop database eq;
create database eq;
source db.sql;

[Xalivor]

thanks trump that worked. But i am still getting errors about 2006. i read the post about it and did this.

mysql> GRANT ALL PRIVILEGES ON eq.* TO Ashy@localhost INDENTIFIED BY <mypass> WIT
H GRAN OPTION

but it didnt do anything that i noticed.

When i open World.exe it still says the same thing listed in previous posts.

[Xalivor]

also in my winmysqladim under process it still doesnt list a DB

[Meekrat]

[Database]
host=localhost
user=my minilogin username
password=my minilogin password
database=eq

You are not putting minilogon user/pass are you? You are putting in the user/pass that you made for MySQL?

Thought i'd ask. Your post was not clear.

[Xalivor]

yeah i think i am. i forgot my MYSQL password/username. But everytime i go to the MS window to fix it nohing happens

[ibleet]

Open up winmysqladmin, your username and password are listed there under the my.ini Setup tab.

[Xalivor]

ok i did and it seems as though its the same as mini login

[ibleet]

Actually minilogin is eqemu eqemu, but any username and pw provided will work.

[Xalivor]

im still getting the same errors

Grr all i wanna do is make items

[Shawn319]

DB.ini HAS to have your mySQL login and password. if you forgot it then delete c:\windows\my.ini then re-run Winmysqladmin.exe and make a new one.