How do I setup MySQL server for my host
#1

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.
Reply
#2

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.
Reply
#3

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.
Reply
#4

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


Forum Jump:


Users browsing this thread: 1 Guest(s)