[NewPlayer]

Hey Guys I m Just Trying to Start a server but it need a mysql database i even created a database for server, But i need help to setup server Any one can help mee pleaseee

[Mark_Weston]

How about explaining what the problem is? We can't help you if you don't tell us...

Also you need a structure/database dump for the server to work, if there isn't one. MAKE one.

Not really hard.

Here: http://www.devshed.com/c/a/mysql/mys...h-basic-guide/

[NewPlayer]

well i created a Datebase now i have to add database information in gamemode and then i have to upload and start ?
or have to do any this else??

[PinEvil]

Tutorials:

[How to make a sa-mp server- https://sampforum.blast.hk/showthread.php?tid=370511]
[How to use mysql in a sa-mp script- https://sampforum.blast.hk/showthread.php?tid=129183]

[Mark_Weston]

Quote:

Originally Posted by NewPlayer well i created a Datebase now i have to add database information in gamemode and then i have to upload and start ? or have to do any this else??

Yes you upload the dump to the table you made or just upload the dump to the SQL Account and it will make a table by it self.

[NewPlayer]

What is Dump and to which tabel ? please lilbit information!!!

[NewPlayer]

Hey Guys
well i please tell me some thing about to edit in pwn file

#define SQL_HOST "Your DB Host" i have to just add my database ip adreas , or i have to add my mysql database with phpmyadmin? like : http:mydatabaseiphere: or http:mydatabaseiphere/phpmyadmin??
#define SQL_USER "DB Username"
#define SQL_PASS "DB Pass"
#define SQL_DB "DB Name"

[S4t3K]

The SQL host is either localhost (127.0.0.1) if you use local sql or the ip/servername of your mysql server if you use hosted/distant sql connection.

For example, on alwaysdata.net,



Take a look at this, then apply what you've seen on my screen to your own case, with your host.

[NewPlayer]

well Bro i m Using a VPS and i have created mysql datebase on my vps so i had data base on ip
for open mysql database i have to go on my VPS ip like this http:myvpsiphere/phpmyadmin
so i have to put
phpmyadmin with vps ip or just ip

[Mark_Weston]

Quote:

Originally Posted by NewPlayer well Bro i m Using a VPS and i have created mysql datebase on my vps so i had data base on ip for open mysql database i have to go on my VPS ip like this http:myvpsiphere/phpmyadmin so i have to put phpmyadmin with vps ip or just ip

The host is the PHPmyadmin IP/VPS IP.

For example:

22.51.62.125/phpmyadmin

Code:

#define SQL_HOST "22.51.62.125" i have to just add my database ip adreas , or i have to add my mysql database with phpmyadmin? like : http:mydatabaseiphere: or http:mydatabaseiphere/phpmyadmin??
#define SQL_USER "username DO NOT USE ROOT/ADMIN ACCOUNT"
#define SQL_PASS "the password for the account that you made"
#define SQL_DB " the database, these are the things on the left at phpmyadmin"

http://i.imgur.com/i3vO16W.png these are the databases