Trouble starting a new server

[Damilis]

Originally Posted by strife01

"Start" then "Run" and type in "C:\mysql\bin\mysql -u root peq". Now type in " GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION; " If you used cavedude's database, replace "peq" with "eq"."

Okay, here's the breakdown of what this step accomplishes. (If I say things you already know or 'talk down' to ya, its only because I don't know your level of expertise, so don't take any of it personally)

Windows Start Menu -> Run
Type in "C:\mysql\bin\mysql -u root peq".
Explanation:
"C:\mysql\bin\mysql" is the path to the mysql terminal interface
"-u" command line argument fed to the mysql terminal interface indicating you want to specify a user
"root" the user mention above
"peq" the specific database you want to use when the mysql terminal interface opens. (optional. If omitted, then your first mysql> prompt command will be "use peq;")

Your DOS prompt should be replaced with the mysql> prompt.
At the mysql> prompt, type the following command:

"GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION;"

Explanation:
"GRANT ALL PRIVILEGES ON " Grants all read/write privileges to the following database.
"peq.*" in this example, 'peq' is the database and '*' is a wildcard for specifying ALL tables.
"TO eq@localhost" in this example, 'eq' is the username and 'localhost' is the machine that 'eq' is allowed to access from.
"IDENTIFIED BY 'eq' " in this example 'eq' is the password required for 'eq@localhost' to connect
"WITH GRANT OPTION" gives the account 'eq@localhost' the ability to change other account permissions.


My notes:
-using the default username and password that comes with the installer, in my opinion, is a huge security risk... use your own.
-you need to be careful with the 'eq@localhost' mentioned above. User 'eq' will only have permissions to access the database if you are using localhost (or 127.0.0.1) in your EQEmu settings (loginserver.ini & eqemu_config.xml). If you change your settings (like I had to) to use the server machine's real IP instead of localhost (or 127.0.0.1) then you might need to add another permissions entry to mysql that reads like so:

"GRANT ALL PRIVILEGES ON peq.* TO eq@192.168.1.2 IDENTIFIED BY 'eq' WITH GRANT OPTION;"




Next step is an explanation of the config files:

loginserver.ini:

###Your current configuration is as follows:
loginserver.ini:
[LoginServer]
loginserver=192.168.1.2 (This is the IP of the login server that you want your world.exe to connect to.)
loginport=5999(This is the port that you want your world.exe to connect on.)
worldname=ShadowsOfNorrath
worldaddress=192.168.1.2(This is the IP of your world.exe that is given to the loginserver so it knows where to send clients to.)
locked=false
account=
password=
[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=
[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

<?xml version="1.0">
<server>
	 <world>
		 <shortname>SON</shortname>
		 <longname>ShadowsOfNorrath</longname>
		 <address>192.168.1.2</address>(This is the IP of your world.exe that is given to the loginserver so it knows where to send clients to.)
locked=false
		 <localaddress>127.0.0.1</localaddress>(This is the IP that the various eqemu executables will use for any 'local' calls)
locked=false


<!-- Loginserver information. -->
		 <loginserver>
			 <host>192.168.1.2</host> (This is the IP of the login server that you want your world.exe to connect to.)
			 <port>5999</port>(This is the port that you want your world.exe to connect on.)
			 <account></account>
			 <password></password>
		 </loginserver>
	 </world>
 
	 <!-- Database configuration, replaces db.ini. -->
	 <database>
		 <host>192.168.1.2</host>
		 <port>3306</port>
		 <username>YOURMOTHERS</username>
		 <password>PASSWORD</password>
		 <db>eq</db>
	 </database>
</server>

Hope that helps you out some as to where to put your numbers Additionally, this knowledge is all from observed behavior of my server, so if a dev has a better/more concise explanation, please feel free to correct me!