[TUT] MySQL Configure - UPDATED 2012-04-08

[Callum]

Why download XAMPP just to install MySQL? That's like downloading GTADownloadManager just to install MTA.

[AJXB]

plz update the file links plzzzzz thks alot but upddate the links

[myonlake]

Exactly. Webhosts do not allow database connections from anywhere else than the server, you can bypass this with PHPSDK for MTA

[uhm]

Yeah, not just free webhosts. It's a pretty big deal security wise to let in SQL sessions over the innerweb. Also I would suggest using localhost instead of 127.0.0.1, because then the MySQL travels through a pipe instead of over TCP protocol (it's more optimized).

http://dev.mysql.com/doc/refman/5.5/en/ ... erver.html

Also I would suggest using MySQL Workbench. It's a GUI for MySQL. The biggest advantage is how it lets you create Entity Relationship Diagrams, which makes implementing the database into the code a lot more clear. It also comes with the newest version of MySQL server.

http://dev.mysql.com/downloads/workbench/5.2.html

[..:D&G:..]

How am i going to download the server.zip? And i really need it, this tut is useless without the proper server.zip link

[Anderl]

Exactly. Webhosts do not allow database connections from anywhere else than the server, you can bypass this with PHPSDK for MTA

There are lots that allow ( if you mean a webhosting service and not a home server - even if it was a home server, it'd be possible ) - You can do that in CPanel ( I don't know if other panels let users do such things because I never used any others ).

[uhm]

Sure they can allow it but it's a gigantic security risk

Hackers need to be successful once and they have all the data of possibly all websites hosted by that user

Disallowing access from anything but localhost is not a bad thing

[zero]

Thanks.

[golanu21]

Error: MySQL shutdown unexpectedly. 
22:08:37  [mysql]   This may be due to a blocked port, missing dependencies,  
22:08:37  [mysql]   improper privileges, a crash, or a shutdown by another method. 
22:08:37  [mysql]   Check the "/xampp/mysql/data/mysql_error.log" file 
22:08:37  [mysql]   and the Windows Event Viewer for more clues 
22:09:43  [mysql]   Attempting to start MySQL service... 

[LilDollaTechZone]

The links are dead, could you provide new links please?

[xXMADEXx]

Thank you, you have helped us all very much.

[Jokeℝ1472771893]

13:04:09  [mysql]   Attempting to start MySQL service... 

I am getting this when I am trying to start MySQL

[codeluaeveryday]

@Joker,

The most common problem is most likely the port, try changing the SQL default port.

[StreetSaintz]

does this still work?

[xXMADEXx]

does this still work?

Yea, however now MTA haves default mta functions so you don't need the modules.

[antonhs35]

In MTA SA anymore use mysql???? For Server

[antonhs35]

In MTA SA anymore use mysql???? For Server

Or That and Download Make???? (MySQL)

[Castillo]

What do you mean?

[antonhs35]

I want to open a server RolePlay!!!

and I don't know what to use mysql !!!

[myonlake]

We don't help with leaked gamemodes, sorry.

[antonhs35]

what do the query?????

and the port of mysql is 3306 .. I put the TCP or UDP????

[THEWES]

Could anybody upload the server.zip files please ?

Links are dead.

Thank you.

[Ryancit2]

Hey..I am new to this..That link isnt working:

- First please download server files needed to run MySQL

server.zip

[Twisted]

Hey..I am new to this..That link isnt working:

- First please download server files needed to run MySQL

server.zip

I believe this has been dead for some time now.

[WhoAmI]

And now It is better to use db function (dbQuery, dbExec, dbPoll), couse of performance and SQL injections.