SA-MP Forums Archive
MYSQL problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL problem (/showthread.php?tid=293270)


MYSQL problem - _ReloadeD_ - 27.10.2011

I did the simple mysql system from this guide:

http://forum.sa-mp.com/showthread.ph...highlight=User

and when I run my server then in says "Connecting to server ...... Didn't respond"
I checked if I put the plugin in the server.cfg and I did......
someone help?

Re: MYSQL problem - [MWR]Blood - 27.10.2011

Did you assure you entered the valid details of your database?
Quote:
Originally Posted by Tutorial
#define mysql_host "127.0.0.1" //Has to be a string
#define mysql_user "root" //Has to be a string
#define mysql_password "" //There is none for wamp unless you set one.
#define mysql_database "sa-mp" //Has to be a string
If you got those, no surprise it's not working.

Re: MYSQL problem - _ReloadeD_ - 28.10.2011

yep I have it.....
what the problem? what should I do?

Re: MYSQL problem - _ReloadeD_ - 28.10.2011

ohhh I am stupid XD
I install the 0.3d samp version and my server is 0.3c version....
but I asked my friend try to register and when he goes out from the server the username don't save.....
I cheacked in the PHPMYADMIN if there are some fields created in my database and there are nothing.....

Re: MYSQL problem - _ReloadeD_ - 28.10.2011

I don't undestand one thing:
Код:
mysql_connect("host", "user", "database", "password");
user and password of what?
I have a DirectAdmin
and when I create a db I have that:
Код:
Your database has been setup. Use the following values:

Database: yan_mode 
Host: localhost 
Username: yan_mode 
Password: XXXXXXX
this is the username and password what I need? or I need to put the password and username of my FTP user?

Re: MYSQL problem - Norn - 28.10.2011

Why would you put the credentials of your FTP server? The tutorial explains it quite simply I'm afraid.

Re: MYSQL problem - _ReloadeD_ - 28.10.2011

then what I need to insert there?
I don't understod well the tutorial......

Re: MYSQL problem - Pinguinn - 28.10.2011

All you gotta remember is that the username and password is needed for MySQL Connection

Re: MYSQL problem - _ReloadeD_ - 28.10.2011

look for post number 5.
this the username and password that I nned?