mysql_connect

[TheNightRider]

Hi there,

I have been working on a home server, running on windows

I have added "" to my mtaserverconf file as first to startup.

I have added "mta_mysql.dll" in the following location

"\Users\User\Desktop\MTA San Andreas\server\mods\deathmatch\modules"

However I get "ERROR: unable to connect to mysql: <2005> Unknown MySQL server host 'IP/DOMAIN' <11004>

Could someone please help me to get this working?

It is the first time for me to use SQL on MTA lol

Thanks

[Castillo]

Mysql requires a Mysql server, do you have it? and you configured your script to work with it?

[Gungneer]

Windows

Uncompress the file mta_mysql.dll into your C:\Program files\MTA San Andreas\server\mods\deathmatch\modules\ directory and the file libmysql.dll into your C:\Program files\MTA San Andreas\server\ directory.

Did you do that as well? (Edit: By "that", I mean the bolded bit, if you can tell it apart)

https://wiki.multitheftauto.com/wiki/Mysql

And like SolidSnake said, make sure you have a MySQL server running.

[TheNightRider]

Thanks could I setup a mysql server on the same computer?

[Castillo]

Yes.

[TheNightRider]

Cool how do I do that?

[Castillo]

Get a program named "xampp", that contains a mysql server, apache, and dunno what else.

[TheNightRider]

Okay thank you for your possitive help

[Gungneer]

I'm with Solidsnake here, if you want the link to the XAMPP program, it's http://www.apachefriends.org/en/xampp-windows.html

If you need any help getting to grips with it, feel free to throw a PM my way, I've been using that program for the better part of 7 years now.

The following is an edit:

Get a program named "xampp", that contains a mysql server, apache, and dunno what else.

You could have also mentioned PHP since that's a pretty useful part of it since he could essentially run a full server (MTA + forum/website) from a house computer. (If that's what he's actually doing.)

[TheNightRider]

Yes its being done from a home computer and having trouble setting xampp up

[Gungneer]

How so?

If you have MSN, feel free to add me on [email protected] for help setting it up.

[TheNightRider]

Will do thanks budy

[TheNightRider]

I am trying to get an mysql.socket file for the sql server but I cannot find 1

Any idea's?

[TheNightRider]

Okay I have finally got the SQL server going and a lot of my script is not working

thanks guys

[TheNightRider]

Edited April 23, 2011 by Guest

[Orange]

Remove

  
SET = SQL_MODE "NO_AUTO_VALUE_ON_ZERO";