MySQL 5.0 Server
MySQL Tools
MySQL Bakups
Download Here
Lets get started by install MySQL 5.0. Select Complete. Skip Sign up.
Configure. Standard Configuration. Dont select include bin directory in windows path.
Enter your password, username is root by default, ill tell you how to change it later.
Also make sure to check the "Enable root access from remote machines". It should be sucessful.
Now Lets get started on setting up the tools.
When you get the choosing screen select custom. And Disable
All except Common Components, Admin, Query Browser, and thats it. Now that we're done
installing lets get started with the db. Connect threw the query browser,
Put ragnarok as the default schema. Then hit Yes.
Now we are going to run the SQL Scripts in the scripts folder, That you downloaded . Now lets do the Administrator.
Click on User Administrator, click on root, and go ahead and change the username.
Now lets make a new user by clicking the button that says "New User" at the buttom left corner
Now make the new user called ragnarok with the password ragnarok.
Now in schema privilages click on ragnarok and click the << button and hit apply.
In conf/char_athena.conf, conf/map_athena.conf, and conf/login_athena.conf do this,
Find:
//login_ip: 127.0.0.1
//bind_ip: 127.0.0.1
//char_ip:127.0.0.1
And remove the // from it to make it look like:
login_ip: Global_IP
bind_ip: Global_IP
char_ip:Global_IP
Find your global IP @ Whatisyourip.com .
Router Users Only
login_ip: Local_IP
bind_ip: Local_IP
char_ip:Local_IP
But if your a router user it should look like that. To find your Local IP, Go to Start-> Run-> Cmd -> Ipconfig, that is your local ip.
Now to forward ports. Do this by going to your router page. Look in ipconfig for the local ip and remove the two last digits and that should be your router ip. Now put it in a browser, and login. Then forward the following ports:
6900
5121
6121
End of Router Users Only
Now to config the conf/grf-files.txt, find:
grf: C:\Program Files\Gravity\RO\data.grf
grf: C:\Program Files\Gravity\RO\sdata.grf
and change it to where your grf files are located.
Now in conf/inter_athena.conf, find:
// MySQL Login SQL Server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db: log
// MySQL Mail SQL Server
mail_server_ip: 127.0.0.1
mail_server_port: 3306
mail_server_id: ragnarok
mail_server_pw: ragnarok
mail_server_db: ragnarok
Change to:
// MySQL Login SQL Server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db: ragnarok
// MySQL Mail SQL Server
mail_server_ip: 127.0.0.1
mail_server_port: 3306
mail_server_id: ragnarok
mail_server_pw: ragnarok
mail_server_db: ragnarok
Now, open Login-server-sql.bat, Map-server-sql.bat, and Char-server-sql.bat,
Or just runserver-sql.bat.
Posts
