MySQL database connection problem.

[Alan.Alexander]

I'm having a wee bit of trouble with using MySQL in MTA .

While on my local, I can run XAMPP and connect to the MySQL easily, but on my Debian 6 server with XAMPP using tyhe exact same tables and script it doesn't seem to want to connect.

Anyone have any idea what the problem might be?

[Baseplate]

Try checking ur hostname, it's not always localhost

[Alan.Alexander]

Try checking ur hostname, it's not always localhost

That's why I was using 127.0.0.1 in the first place.

[Baseplate]

:facepalm:

127.0.0.1=localhost

[Entity]

Try using your internal IP address.

Edited September 20, 2012 by Guest

[Alan.Alexander]

Try using your internal IP address. You can get it by opening cmd and typing 'ipconfig'.

I'm not sure you read my first post, but I'm running this on a Debian 6 server? ipconfig doesn't work like that and I'm a bit of a noob with Linux...

[Entity]

Try to type this in console:

/sbin/ifconfig 

Edited September 20, 2012 by Guest

[Alan.Alexander]

I've tried using 127.0.0.1, 127.0.0.2 (both were listed in ifconfig) and my external IP address... Nothing's working.

[Entity]

http://www.if-not-true-then-false.com/2010/linux-get-ip-address/

[Alan.Alexander]

I used example 1.2, I'm getting this...

lo: 127.0.0.1

venet0: 127.0.0.2

venet0: addr

[Entity]

Sorry, I don't know much about Linux, but you can still create account on the following sites and get free hosting with database hosting:

http://www.cwahi.net/

http://byethost.com/

http://www.000webhost.com/

[DiSaMe]

Remote MySQL connections in 000webhost are disabled for free accounts.

[Alan.Alexander]

I think I'ma just use SQLite 'cause fuck MySQL since it's being a bitch. Cheers for the help though guys.

[Jaysds1]

sorry, I know this late but maybe you could use this free mysql hosting: http://www.bizhostnet.com/

[xXMADEXx]

In your mtaserver.config, make sure your IP is 192.168.1.1 or 192.168.1.2 or 192.168.1.3 or 192.168.1.4 or 192.168.1.5, one of those 5. Normally it will be 192.168.1.2 & the one that works, connect to your server with it.

[Anderl]

:facepalm:

127.0.0.1=localhost

As far as I know, localhost doesn't exist in Linux so localhost can't be used. So you can't say localhost is the same as 127.0.0.1 as with localhost it won't work.

[DiSaMe]

Localhost does exist in Linux. I write 'ping localhost' in the terminal and it works as if I wrote 'ping 127.0.0.1'.

[Anderl]

Localhost does exist in Linux. I write 'ping localhost' in the terminal and it works as if I wrote 'ping 127.0.0.1'.

Oh, ok.. I saw somewhere that it didn't exist in Linux ._.