SA-MP Forums Archive
Help - 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: Help (/showthread.php?tid=369685)


Help - Flanjak - 17.08.2012

I need help, I have a gamemode that works with mysql database and I have a webhost and gamehost, but I do not know how to fill in the pwn file connection to database and also the database in order to adjust the "Host"

this is shared IP:
1. #define MYSQL_HOST "68.168.209.242" <<<< what to write here? in my cpanel is only written Shared IP:
#define MYSQL_USER "crogamin_game"
#define MYSQL_PASS "progame"
#define MYSQL_DB "crogamin_csrp" <<<< SHOULD IT BE "crogamin_csrp" OR ONLY "csrp"

2. i uploaded my database to the web hosting
--
Код:
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost    <<<< IF MY DATABAASE IS ON WEB HOST HOW SHOULD I LEAVE THIS, LIKE LOCALHOST OR???
-- Generation Time: Jun 24, 2012 at 01:20 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `crogamin_csrp`
--
this is written in my database, should i change it if i want to connect my GM from gamehost to the database which is on webhostin

Sry for bad english.

Re: Help - Cena44 - 17.08.2012

MYSQL_DB must be the name of the database you uploaded your files at