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

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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 😉

This entry was posted in technology information. Bookmark the permalink.

One Response to Installing PvPGN with MySQL on TSL 3.0

  1. deroozano says:

    mas riza,

    saya baru setup pvpgn di slackware, kl boleh tau untuk iptablenya gimana yah? n pvpgnnya itu di belakang mikrotik.

    thx

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>