in need of help makein a server

[ebeny1359]

i know ya may see a lot of post like this and im sorry and im sorry if its in the wrong topic but here gos. evertime i try to make a new mysql data base i get the error that i havent the artherisation to do so i look through the forms and tryed everything here nothin seems to be workin so i turn to askin for help im runnin a win xp 1.10 ghz compaq.
i know how to do alot of pc stuff this is just not workin for me for some reson.
if i can get this goin anyone that offers sound help can be a gm on my server no questions.

simple part time server is what im lookin to get goin till i get to know wtf everythin is in it then who knows after that. just want to try somethin new live eq has turn into a haven for the noobs., and found one server on this i dont know wtf is with half the 65 snobs lol kiddin everyones been cool please help me out thanks alot

[omper]

do this..

cmd prompt

cd \mysql\bin
mysql -u root mysql
drop database eq;
create database eq;
use eq;
source DB.sql;
\q
end
exit
done.....

Omper

[Bearik]

Originally Posted by omper

do this..

cmd prompt

cd \mysql\bin
mysql -u root mysql
drop database eq;
create database eq;
use eq;
source DB.sql;
\q
end
exit
done.....

Omper

cmd prompt

cd \mysql\bin
mysql -u root mysql
drop database eq;
grant all privileges on *.* to username@localhost identified by 'password' with grant option;
create database eq;
use eq;
source DB.sql;
\q
end
exit
done.....

If hes getting authorization errors it might be a good idea to get the right privileges

[omper]

true.. but my post was to get him in the right DB.. then to add priv.. then set his server op..

was basicaly to make sure he had an EQ database..

Omper

[ebeny1359]

kk thanks for the support new problum seems i cant get on my own server ive been through the forms cant find anything that doesent read like greek to me everything seems to load ok:

world.exe states (sayin my ip here for my ip addy)
unknowen "compression" setting in db.inii
(status) current_world_version:eqemu 0,5,2
(status) loading variables....
(status) loading zones...
(status) loading items...
(status) emusharemem loaded
(status) loading items from database: count=26659, max id=68199
(status) loginserver.ini read.
(status) loading guild ranks..
(status) loading addon.ini..
(status) loading eq time of day..
(status) reboot zone modes on
(status) delete 0 stale player corpses from database
(status) delete 0 stale player backups from database
warning: you need to get laid... (lmfao im not disclosein my sex life here)
tpc listening on: my ip :9000
world server listening on :9000
i load boot5zone and five more dos windos come up assumein this is the zones loadin up and that adds to the world dos window assumin this is all normal in the server start up

now from there i load eqemu and find my server up open and looking like it's ready try to log in and get error 1017 (before ya ask last patch was before the 18th closer to the first of the month with this eq folder) i just want my server to run this is the closest ive ever been please help me out below are any other files ya may need to look at with replace ment of my true ip with myip as well as any stuff for my sql thing replaced with myun or mypw

boot5zone
if NOT exist spells_en.txt goto NOSPELL

start Zone.exe . myip 7995 myip
start Zone.exe . myip 7996 my ip
start Zone.exe . myip 7997 myip
start Zone.exe . myip 7998 myip
start Zone.exe . myip 7999 myip
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

db.ini
# READ README.TXT!

[Database]
host=localhost
user=myun
password=mypw
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

login.ini
# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Demon Labs
worldaddress=myip
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

if i missed anything ya need to see let me know the database i have seems to load ok and i dont see any errors in loadin what am i doin wrong : please please help me *gets on his knees and begs* im so stuck thanks in advance for anything yas can advice me on with your infinite widom

ps: feel free to im me on any of the four messenger trillian works wonders

[clementinex]

hmm i had the same exact problems as this guy but now i have my server up and i get on create a character and i can't get into any zones it says they are all down how do i boot up zones? any help would be greatly appreciated

[Lurker_005]

Test it with localhost in for all your IP's, you have to run EQ on same box as the server though. If that works you are either using the wrong IP, or have problems with a router/firewall not fowarding the correct ports to your computer.