MySQL on Windows

Welcome LAN Party administrators! By now you've surely joined the hundreds of LAN Parties worldwide that enjoyed the many benefits of using the Autonomous LAN Party project at their event. We hope that it has been useful in coordinating tournaments, game servers, and caffeine consumption. Unfortunately, it is with dismay that I must announce the nerdclub programming team has disbanded some time ago and will no longer be holding LAN events or developing the project. However, our love for tournaments and the competitive spirit is not dead. Many years and programming experience level-ups later, we've decided to continue the project's core focus in a new tournament administration website: Tournology.

Tournology will focus on the tournament administration and participation aspects for all types of events, as well as serving as a toolkit to be integrated into other niche software packages requiring a simple, easy, usable tournament solution.

Curious to learn more about Tournology? Check out tournology.com

Referrers

...ridesw.happyhost.org

...rettyw.happyhost.org

...ovemaw.happyhost.org

...ssianw.happyhost.org

...anbriw.happyhost.org

...seksew.happyhost.org

zsekseq.cwahi.net

...vnicaw.happyhost.org

...lubovnicaq.cwahi.net

...seksew.happyhost.org

MySQL on Windows

Note: Your installation directory for MySQL will be referred to as MYSQL_DIR. For example, the typical installation directory is C:\mysql.

Go into your MYSQL_DIR\bin folder and open the program called mysqladmin.exe. It will ask you to create a default username and password for your MySQL account. Do it.

Open up a command prompt window:

Windows 2000/XP: Start -> Run -> cmd
Windows 9x: Start -> Run -> command

Change the directory to MYSQL_DIR\bin by using the command cd. Leave out the drive name and the colon. So, typically, you'd run the command cd \mysql\bin\.

In the command prompt window, log in to your MySQL server by running the command mysql -u root -p. It will ask you for a password, but the default is just blank, so hit enter.

Create a database for the ALP software by using this command: CREATE DATABASE YOUR_DATABASE_NAME;
Substitute the name of the database for YOUR_DATABASE_NAME.

Now you need to create a new account for ALP to use. Run the following command: GRANT CREATE,DROP,SELECT,INSERT,UPDATE,DELETE,ALTER ON YOUR_DATABASE_NAME.* TO YOUR_MYSQL_USERNAME@localhost IDENTIFIED BY 'YOUR_MYSQL_PASSWORD'; YOUR_DATABASE_NAME, YOUR_MYSQL_USERNAME and YOUR_MYSQL_PASSWORD will need to be changed to the values that match what you are going to put into your config file (_config.php) later. As a security measure, this account will not have root privileges.

Now you need to secure your installation. By default, if anyone has physical access to your server (or Windows Terminal access), they can login to the MySQL server without a password. Run the following commands:

USE mysql
DELETE FROM user WHERE User='';
UPDATE user SET Password = PASSWORD('my_passwd') WHERE User='root';
You should substitute your own strong password for my_passwd.

To further secure your installation, you should add the bind-address=127.0.0.1 line to a MySQL option file. By doing this, the MySQL server should only listen for connections on the local system.

Make sure you restart your MySQL server, because it won't recognize the new users and privilege changes until after you restart the MySQL server.

After setting up the ALP software, you should lock down the MySQL account for the ALP software. To do this, log in as root and run the following command:

REVOKE CREATE,DROP,ALTER on YOUR_DATABASE_NAME.* FROM YOUR_MYSQL_USERNAME@localhost;

When updating the ALP software, you should temporarily allow the CREATE, DROP and ALTER privileges. To do this, log in as root and run the following command:

GRANT CREATE,DROP,ALTER on YOUR_DATABASE_NAME.* TO YOUR_MYSQL_USERNAME@localhost;

After doing the update, you should lock down the MySQL account as described in step 10 above.