Installing PvPGN with MySQL on TSL 3.0

hi readers,

yesterday i managed to install a PvPGN on TSL 3.0, PvPGN is a server for Blizzard game, such a popular warcraft III and it map DoTA. Actually i never did it before, so this is my first and i think its nice if i come to share my experience to you. The install process it self is fairly moderate so this is not gonna be a long story.

i decided to use TSL 3.0 which come with mysql 4.1.15 which is one of the databases type needed by PvPGN installation, mysql used to anticipate more user to come since it will serve as a local game server for the entire lintasbuana network in medan and other city around it. i expected hundreds user will use it, if it realy stable in operation.

As i did before, you can jump over installation doc to get more about how to do it, as i can tell you it works and it fairly easy. what it is not there is how to setup the databases, you need to do it first. Since i work with shell then i use mysql client to setup the database and it user. So i assume you have root access for mysql,

rizahnst@game113c ~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 45 to server version: 4.1.15

mysql> CREATE DATABASE pvpgn;
Query OK, 1 row affected (0.00 sec)
 
mysql> GRANT ALL PRIVILEGES ON pvpgn.* TO "pvpgn"@"localhost"

    -> IDENTIFIED BY "password";

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES

 Query OK, 0 rows affected (0.01 sec)

mysql> EXIT

Bye
$ 

if you set it up correctly and follow the installation doc carefully then i am pretty sure it will works, like i did 😉