MySQL Setup

From VbGORE Visual Basic Online RPG Engine

MySQL

What is MySQL?

MySQL is a powerful multi-purpose database. It runs as a service on your computer, which means that it will work in the background when your computer is running. Don't worry, it will use very little RAM and no CPU if you don't use it. MySQL works by getting a query string from the client, then returns the requested information. It uses a very simplistic language format for the query, but has very powerful functions. Many games today uses a MSSQL or MySQL database, from Trickster to World of Warcraft. Since vbGORE version 0.2.0, MySQL has been added to replace the editors and hard to work with file formats. MySQL also allows for remote connections so you can edit from other computers without moving any of the data, along with being able to read the information through web pages.

Downloading

A few files must be downloaded first. These files are all guaranteed to be safe to run, and will not cause any harm to your computer. When you click on each link to download do not worry about any of the other files that come up. Close out of the windows. You will get to them later.

1. Click to download MySQL. If and only if this download does not work for you, you may try an alternative download from the MySQL 5.0 site here.

2. Click to download ODBC 3.51. If and only if this download does not work for you, you may try an alternative download from the ODBC 3.51 site here.

3. Click to download SQLyog. A MySQL GUI will be required. We recommend SQLyog for a free GUI, but if there is another you prefer to use, please feel free to do so. This guide will refer to using SQLyog, though.

Installing MySQL

1. The first thing you need to do is to remove ALL traces of MySQL if you installed it before. First, remove it with Add / Remove Programs in the control panel. After that, go to where MySQL was installed (default "C:\Program Files\MySQL") and delete MySQL manually.

2. Extract the ZIP file and run the MySQL setup.

3. After running the application, you should see the following page. Just hit Next through the pages - the default settings are all you need.

4. When the installer finishes, make sure you tick the Configure the MySQL Server now box ticked, then press Finish. If you don't configure the server now, you can always configure it later. A shortcut should be placed in your start menu to it with a name similar to Configure MySQL instance.

Mysqlfinish.png

Configure MySQL

1. A new application should pop up. Click Next to reach the following page, then tick the Detailed Configuration option.

Mysqlconfig2.png

3. Select developer machine.

Mysqlconfig3.png

4. Select Multifunctional database.

Mysqlconfig4.png

5. Click Next.

Mysqlconfig5.png

6. Select Decision Support.

Mysqlconfig6.png

7. If you want to ever connect to your database remotely (from other computers), select Enable TCP/IP Networking. If you only want to run it from the same computer the game server is on, you can leave this unticked. It is recommended you do tick it for later usage.

Mysqlconfig7.png

8. Select Standard Character Set.

Mysqlconfig8.png

9. Select Install As Windows Service. The service name does not matter - they all do the same. This will allow MySQL to run in the background every time Windows loads.

Mysqlconfig9.png

10. Enter in the password for your database. If you enter in the password as test, you do not have to follow the Set Your Database Password step.

Mysqlconfig10.png

11. Click the Execute button.

Mysqlconfig11.png

12. You may receive an error about a firewall. If pressing Retry a few times does not work, disable any firewalls you have running.

Mysqlconfig12.png

If you have installed it already and reinstalled it you have to do several steps. Go to start>All program>Mysql>MySQL Server Instance Config Wizard

Double Click on it and start it up. Just go through the default settings. Also, don't forget to change your password(even if it is the same) during the config wizard.

Installing ODBC Connector

1. Run odbc351.msi.

2. Follow the steps, using the default settings.

MySQL Videos

Installing MySQL Video

Configuring MySQL

Videos By NotExistant (Arie Miller) sorry for bad quality I blame windows movie maker.

MySQL GUIs

SQLyog (free)

1. Run sqlyog603.exe that was downloaded earlier.

Sqlyog1.png

2. Continue through the setup using the settings of your choice.

3. Configure the MySQL connection values as displayed below. In the password field, enter the password you entered into the MySQL Instance Configuration.

Vbgore.png

4. Now we have to import the database information that comes with vbGORE. Right-click on the left panel and select Create Database. Name your database vbgore, all lower case.

Vbgore2.png Vbgore3.png

5. Right click the vbGORE database and click Restore from SQL dump browse for vbgore.sql and press execute. After you press execute once, click close. Pressing execute will give you an error that simply means you have already imported the data.

Important: If you get an error message saying "Error Code: 1050 - Table 'banned_ips' already exists" or something like that, it means that you already imported the data either before, or you just did. SQLyog is strange on its way of reporting a successful import, so it is very easy to do it without realizing it. If you get this message, just move on, since you're done with this step.

Vbgore4.png Vbgore5.png Vbgore6.png

More Videos

setting up SQLyog video again by Arie Miller :P

Navicat (Not free)

NOTE: Navicat is an optional GUI for MySQL if you don't want to use, or if you want an alternative to, SQLyog. You do not need it to run vbGore.

1. Download Navicat: Go to the Navicat Download Page. Make sure you get the version for MySQL and Windows. Follow the application's directions to install it.

2. Configuring Navicat: When you open Navicat, you should see a button Connect in the top-left corner. Click it, and you will be presented with a new screen. Enter the information as follows, then click OK:

  • Connect Name: <anything you want, such as My computer>
  • Host name/IP address: localhost
  • Port: 3306
  • User name: <leave blank>
  • Password: <password you entered in the MySQL configuration>

3. Creating the vbGORE database: Click on the connection you added (presented in the left side of the screen) and you will see a list of databases. Right-click the name of your connection and click New Database. Enter in the name of your database (vbgore in this case) and click OK.

4. Importing the vbGORE information: Right-click the vbgore database you added and click Execute batch file. Browse to your vbGORE folder, and go into the _Database Dump folder, and select the vbgore.sql file and press Open. Your database is now ready for vbGORE.

Set Your Database Password

NOTE: You only need to do this step if you haven't set your password to test.

This allows you to set any password for your MySQL Game Database. To set the password, open up the Server.ini file (preferably in notepad, wordpad, or a similar file), located in the ServerData folder (\ServerData\Server.ini). From there, enter the same password you entered in the MySQL Server Instance Config Wizard into the Password line of the file. In the file, the line looks similar to this:

<ini> //Password for the username specified above for the database - same as the password entered into the MySQL Instance Config Password=test </ini>

Troubleshooting

Cannot create Windows service for MySQL

If you are getting an error message for MySQL 5.0 during the execute procedure, and the error is "Cannot create Windows service for MySql. Error: 0" the usual problem is the install directory, C:/Program Files/..... The space between Program & Files also prevents MySQL from creating/starting service, so install MySQL server in C:/ itself (ex: C:/MYSQL).

Access denied

Access denied simply means that the username and password you entered for the database was invalid. This is a very common error people have on their first time trying to run vbGORE. The password is the same password you entered into the MySQL Instance Configuration after installing MySQL. The username is often left as root for the primary account.

These values can be changed in the server's configuration file, which is found in root/ServerData/Server.ini on the following lines:

<ini> //MySQL account username (default is "root") User=root

//Password for the username specified above for the database - same as the password entered into the MySQL Instance Config Password=test </ini>

If you try to save the file and you can't you'll have to do one of the steps below:

1. Ask the administrator of the computer to give you privileges.

2. Move the location of the vbgore folder to somewhere else like the desktop.

Can't connect to MySQL server

A Can't connect to MySQL server error often means one of the following:

  • The MySQL service is not running or not installed
  • An invalid server IP or port was entered
  • A firewall or unopened ports (port forwarding) prevent access to the server (remote only)

By default, MySQL is set up to run on the same computer as the vbGORE server. If this is the configuration you are using, too, then you should not have to worry about changing the IP or Port for MySQL. If you are running MySQL remotely, then you will need to change these values. These values can be changed in the server's configuration file, which is found in root/ServerData/Server.ini on the following lines:

<ini> //External IP of the MySQL host ("75.197.223.6" for hosted locally [on the same computer as the server]) Host=75.197.223.6


//Port of the MySQL database (default is "3306") Port=3306 </ini>

Keep in mind that the Host requires the external IP, not internal. You can get this IP by going on the host machine and going to WhatIsMyIP.org or other similar sites if you do not already know the IP.

If you are hosting locally, the problem is most likely that you do not have the service running. The first step is to make sure you have installed MySQL and run the MySQL Instance Configuration successfully. If the service will still not load, you can load it manually through:

Right-click 'My Computer' -> 'Manage' -> 'Services and Applications' -> 'Services'

Find your MySQL service in this list (name usually starts with 'MySQL'), right-click it and click 'Start'

Unknown database

Unknown Database means that you have connected to MySQL, but the database you specified does not exist. By default, this is the vbgore database. Make sure that you have imported the vbgore.sql file into the database with SQLyog, Navicat or your MySQL GUI of preference.

The name of the database can be changed in the root/ServerData/Server.ini file on the line:

<ini> //Name of the MySQL database (default is "vbgore") Database=vbgore</ini>

Driver not found

Data source name not found and no default driver specified means that you did not install ODBC, or your installed an invalid version of ODBC. Please make sure you download and install ODBC v3.51. Any other version of ODBC is not guaranteed to work.

ODBC allows vbGORE to connect to the MySQL server. This is a required application on any computer trying to connect to MySQL with vbGORE. That means any computer running the map editor, server, or any other vbGORE program / tool that uses the database must install this. You do not need to include this for general usage downloads, though, since only the server and development tools connect to the database.

Table doesn't exist

A table doesn't exist error means that one or more of the tables required by vbGORE could not be found in your database. The most common cause of this is failure to import the vbgore.sql file into the database. Make sure that you have imported the vbgore.sql file into the database with SQLyog, Navicat or your MySQL GUI of preference.

Other Languages

Dutch/Nederlands: MySQL_Setup_NL

Personal tools