Set up MySQL

Setting up an fpdb database in MySQL

Step 1. Start the MySQL Command Line Client

Windows users should be able to start it from the Start menu. Linux users (and Windows users who don't have a mysql entry in their Start menu) give this command in a terminal window:

mysql -u root -p

Respond to the password prompt with the root password for your mysql installation. If a root password has never been specified then the root password is empty—that is just hit enter at the pasword prompt. (If you have forgotten you root password, use [guide] on the MySQL site to reset it.) You should see something like this:
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7993
Server version: 5.0.67 Source distribution

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

mysql>

Step 2. Delete the Old fpdb Database

at the mysql> prompt enter SHOW DATABASES; You should get a response that looks something like this:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| fpdb               |
| fpdbTEST           |
| fpdb_test          |
| mythconverg        |
| test               |
| tester             |
+--------------------+
8 rows in set (0.06 sec)

If you don't see fpdb in the list, skip to the next step. If it is in the list, delete it with DROP DATABASE fpdb; command and verify that it worked by using the SHOW DATABASES; command again. The response should look like this (except that I dropped the fpdb_test database):
mysql> DROP DATABASE fpdb_test;
Query OK, 13 rows affected (0.71 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| PTrackSv2          |
| fpdb               |
| fpdbTEST           |
| mythconverg        |
| test               |
| tester             |
+--------------------+
7 rows in set (0.00 sec)

Step 3. Create a New fpdb Database

Enter the command CREATE DATABASE fpdb;. Verify with SHOW DATABASES; Example:

mysql> CREATE DATABASE fpdb;
Query OK, 1 row affected (0.01 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| PTrackSv2          |
| fpdb               |
| fpdbTEST           |
| mythconverg        |
| test               |
| tester             |
+--------------------+
8 rows in set (0.00 sec)

mysql>

Step 4. Assign Permissions to the fpdb Database

The fpdb user needs persmission to use and modify the fpdb database. Enter these commands(change "newPassword" to your new password for the fpdb user):

GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;

You can check to see that permissions were granted by entering this command: SHOW GRANTS FOR fpdb@localhost; Resposnse should look like this:
mysql> show grants for fpdb@'localhost';
+-------------------------------------------------------------------------------------------------------------------+
| Grants for fpdb@localhost                                                                                         |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON `fpdb`.* TO 'fpdb'@'localhost' IDENTIFIED BY PASSWORD '0476fc026afffe24' WITH GRANT OPTION|
+-------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> exit;
Bye

Step 5. Edit Your HUD_config.xml File

You can exit the MySQL client, as seen above. Now open your HUD_config.xml file in a text editor and change the database settings. If you don't know how to find your HUD_config.xml file, see Confirm config file location. Change the <supported databases> element to look like this. (Change "newPassword" to the password you set up in Step 4.):

    <supported_databases>
        <database db_name="fpdb"         db_server="mysql"      db_ip="localhost" db_user="fpdb"   db_pass="newPassword" db_type="fpdb">    </database>
    </supported_databases>

Step 6. Play Poker

You should now be able to bulk import, use the HUD, play poker, check-raise, slow play, win money, etc.

web analytics

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License