Mysql starting server 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: Mysql starting server help (/showthread.php?tid=514574)
+- 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: Mysql starting server help (/showthread.php?tid=514574)
Mysql starting server help - NewPlayer - 22.05.2014
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
Re: Mysql starting server help - Mark_Weston - 22.05.2014
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/
Re: Mysql starting server help - NewPlayer - 22.05.2014
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??
Re: Mysql starting server help - PinEvil - 22.05.2014
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]
Re: Mysql starting server help - Mark_Weston - 22.05.2014
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?? |
Re: Mysql starting server help - NewPlayer - 23.05.2014
What is Dump and to which tabel ? please lilbit information!!!
Re: Mysql starting server help - NewPlayer - 23.05.2014
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"
Re : Mysql starting server help - S4t3K - 23.05.2014
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.
Re: Mysql starting server help - NewPlayer - 23.05.2014
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
Re: Mysql starting server help - Mark_Weston - 23.05.2014
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 |
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"