How do i change MySql Username/Pass for my Server?
 

I have problems starting my own server.
I used Jezebell's Guide which was very easy to use. But i do have a problem, and when i run boot5zones.bat, it brings up the 6 windows with all the same error:.... :evil:


<prev txt here>.........
[Error] Loading npcs FAILED!
===============================
Runtime errors:

MySQL Error #1405 or $2001 means your mysql server rejected the username and password you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=1

Hit any key to exit



.... Well The website link does not work and i am not sure where i can change the username and pass for this...

Also, Which username pass do i use? A new one? the EQemu server username pass? and which one is causing the error?
:?: :?: :?: :?: :?: :?:

start/run/cmd

mysql -u root

grant all privileges on *.* to fred@localhost identified by 'fred' with grant option;

Edit your db.ini file and change the user and password fields to

user=fred
password=fred

or whaterever user and password you choose. Make sure there are no spaces at the end of any line, i.e. go to each line, press the 'END' key and press backspace if there is a space between the last character of the line and where your cursor is.

Make sure you type the grant command exactly as above, i.e. single quotes around the password (the second 'fred' in my example).

you can edit your password/username in c:\windows\my.ini I guess.

I got a new error now :)
any idea what i did wrong?

WorldServer connect: Connecting to the server failed: TCPConnection::Connect<>:Couldnt resolve hostname. Error: 11001
[Error] worldserver.Connect <> FAILED!
[Status] Entering Sleepmode

11001 is a 'host not found' winsock error. Post your loginserver.ini, and also your boot5zones.bat file.

LoginServer.ini


[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Yourservername
worldaddress=YourexternalIPAddress
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=YourInternalIPAddress




boot5zones.bat


REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
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

REM:---------------END------------------------

not sure what i put inplace of YourIpAddress
so let me know

To get YourInternalIP address:

start/run/cmd

c:\windows\system32\ipconfig

your internal IP address is on the line beginning 'IP Address'

To get YourExternalIP address:

goto http://www.whatsmyip.org

Where you have <4 digit number> in your boot5zones.bat, replace with 7995 for the first 'start zone' command, 7996 for the second, 7997 for the next, and so on.

where do i replace that at?

ok done with the boot5zone
What do i replace in the loginserver.ini?

Change these lines

worldname=Infernal Test Server
worldaddress=Whatever Your external IP Address is

ChatChannelServer=Your InternalIP Address

whats the difference between internal and external ip address?

Where do i find the internal one and where the external...

i got the one from www.whatismyip.org

... whats the internal one then?

Umm, from my post a few posts up in this thread:

the 2 of them are the same....
True?

gave me the exact same error.. heres my
LoginServer.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Infernal Test [Dev]
worldaddress=68.104.241.117
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=68.104.241.117

and my boot5zones.bat

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . YourExternalIP 7995 YourInternalIP
start zone . YourExternalIP 7996 YourInternalIP
start zone . YourExternalIP 7997 YourInternalIP
start zone . YourExternalIP 7998 YourInternalIP
start zone . YourExternalIP 7999 YourInternalIP
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

REM:---------------END------------------------