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. |
Also, there's a post about 2006 error on the top of this forum.
|
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 |
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.
|
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 |
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; |
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. |
also in my winmysqladim under process it still doesnt list a DB
|
user/pass??
[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. |
yeah i think i am. i forgot my MYSQL password/username. But everytime i go to the MS window to fix it nohing happens
|
Open up winmysqladmin, your username and password are listed there under the my.ini Setup tab.
|
ok i did and it seems as though its the same as mini login
|
Actually minilogin is eqemu eqemu, but any username and pw provided will work.
|
im still getting the same errors
Grr all i wanna do is make items |
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.
|
All times are GMT -4. The time now is 05:24 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.