• Spoiler tag your spoilers, please. That includes all unknown content from the DLC that was not shown in trailers or discussed in pre-release interviews.

MySql Trouble



REGISTER TO REMOVE ADS

Akai

Oh.
Joined
Jan 16, 2004
Messages
420
Awards
0
Age
29
Location
My world.
Ok, this is my problem. I'm hosting my Vbulletin forums on my computer with a server (Abyss), MySql, PHP. Now, it's starting to lag my game server, so I wanted to move the forums to a dedicated web hosting company. So I purchased hosting from http://1and1.com . For some reason they're MySql is like wacked, so I have to use MySql that is running on my computer.

Well, I can't seem to get the hosting to connect with my MySql. In the Vbulletin forums you have two files called "config.php" and "config.php.new" well inside theres this:

"// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = '';

Now, since I'm not using 1and1's MySql, I'm using mine. I would put "localhost" in "
$config['MasterServer']['servername'] = " right? That's what I think. And I have the port 3306 port forwarded TCP and UDP. But for some reason the forum still won't connect with the MySql. So someone told me that I have to allow it to connect, well, is that by adding a user? I don't see how. I do have phpmyadmin.

Here is the site that won't connect with my MySql http://kivamage.net (or http://kivamage.com) If someone could help me that would be great. And I would be happy to post config.php and config.php.new if needed or anything else.

Also if you need my msn to direct talk then message here. Thanks!
 

Azurith

Member
Joined
Aug 10, 2005
Messages
616
Awards
1
Location
Angels of darkness tread softly in the light.
  • Retired Staff
Akai said:
Ok, this is my problem. I'm hosting my Vbulletin forums on my computer with a server (Abyss), MySql, PHP. Now, it's starting to lag my game server, so I wanted to move the forums to a dedicated web hosting company. So I purchased hosting from http://1and1.com . For some reason they're MySql is like wacked, so I have to use MySql that is running on my computer.

Well, I can't seem to get the hosting to connect with my MySql. In the Vbulletin forums you have two files called "config.php" and "config.php.new" well inside theres this:

"// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = '';

Now, since I'm not using 1and1's MySql, I'm using mine. I would put "localhost" in "
$config['MasterServer']['servername'] = " right? That's what I think. And I have the port 3306 port forwarded TCP and UDP. But for some reason the forum still won't connect with the MySql. So someone told me that I have to allow it to connect, well, is that by adding a user? I don't see how. I do have phpmyadmin.

Here is the site that won't connect with my MySql http://kivamage.net (or http://kivamage.com) If someone could help me that would be great. And I would be happy to post config.php and config.php.new if needed or anything else.

Also if you need my msn to direct talk then message here. Thanks!
I already see the problem here..
The 'localhost' ip address ALWAYS 127.0.0.1... aka 'home'.. or otherwise known as THAT particular machine.. ie that server's internal ip address.. EVERY computer in the world has an ip of 127.0.0.1. It's a loopback ip address for the computer.
Instead of using 'local' host.. you need to find your computer's ip address.
(http://www.whatismyipaddress.com) and use that instead. 'Localhost' and '127.0.0.1' are both defined as the local machine, thus 'local host' so the server is trying to connect to the MySql database on the server, and not on your pc. And that's the problem.

Also, make sure your ports are properly configured, and routed through your WLAN/LAN, if you've got one setup.

And that should take care of that problem for you.

~~Azurith
 
Top