How do I setup MySQL server for my host

How do I setup MySQL server for my host - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: How do I setup MySQL server for my host (/showthread.php?tid=419820)

How do I setup MySQL server for my host - Eminem 2ka9 - 02.03.2013

I'm using Volt-Host. It has a MySQL database. When I go into my gamemode and insert the name of my database, the server doesn't load the MySQL database. Am I missing something?

pawn Код:

#define mysql_host          "localhost" //I believe this should be changed to my hosts IP?
#define mysql_user          "root" //What is this used for?
#define mysql_password      "" //Do I need this?
#define mysql_database      "battlefield" //Where do i find the name of my database? It says something like "8081_battlefield" on my MySQL host.

REP+ for working solution.

Re: How do I setup MySQL server for my host - Scenario - 02.03.2013

mysql_host is the IP of your server, generally
mysql_user is the username associated with your SQL database
mysql_password is the password associated with your SQL database
mysql_database is the database you're going to associate with your SA:MP server

Open a support ticket with Volt for additional information.

Re: How do I setup MySQL server for my host - Eminem 2ka9 - 02.03.2013

Quote:

Originally Posted by RealCop228

mysql_host is the IP of your server, generally
mysql_user is the username associated with your SQL database
mysql_password is the password associated with your SQL database
mysql_database is the database you're going to associate with your SA:MP server

Open a support ticket with Volt for additional information.

Will i put my host like this with the :7782 at the end? or..?

pawn Код:

#define mysql_host          "109.76.59.124:7782"

Thanks.

Re: How do I setup MySQL server for my host - ColorHost-Kevin - 02.03.2013

The Port is usually not needed, only the IP. (As with most, the port for MYSQL is automatically detected, which is 3306.)