SA-MP Forums Archive
•MYSQL small problem. - 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 small problem. (/showthread.php?tid=484370)


•MYSQL small problem. - Gregory00 - 30.12.2013

I am a newbie scripter. I dont know ANYTHING about MYSQL and I need your help. How can I fix thi when I open the samp-server.exe?

Code:
[17:23:29] [MySQL] Error (0): Failed to connect. Can't connect to MySQL server on 'localhost' (10061).
[17:23:29] [MySQL] Error (0): Function: mysql_ping called when not connected to any database. Can't connect to MySQL server on 'localhost' (10061).
[17:23:29] MySQL-Verbindung wurde erfolgreich hergestellt


Re: •MYSQL small problem. - Khanz - 30.12.2013

The message is saying it's failing to connect to your MySQL server that is on your local PC, you either supplied the incorrect version or don't have MySQL installed.

Re: •MYSQL small problem. - kN1GhT - 30.12.2013

the error seems to come due to failed connection to the MySQL server

Check the mysql_connect statement and check wether you have entered the right server property for the localhost

Re: •MYSQL small problem. - Gregory00 - 30.12.2013

I have no idea what you saying guys...btw, how to install or update the mysql?
Add me on skype please (gregor.kouk)

Re: •MYSQL small problem. - kN1GhT - 30.12.2013

U need a MySQL host or a wamp server(it runs the database on your comp)

Re: •MYSQL small problem. - Walkie - 30.12.2013

If you use a host , check if you have permission to connect , if you use your PC , try with xamp !

Re: •MYSQL small problem. - HB - 30.12.2013

To install MySQL, I suggest you use the following package: http://www.apachefriends.org/en/xampp-windows.html

It comes with the standard username of "root". The password is empty, but you can change it at this link whenever you installed the program: http://localhost/security/xamppsecurity.php (you need to run "Apache" with the xampp control panel for this to work).

Followingly you'd want to create a database that your server requires. Go to http://localhost/phpmyadmin/ to access your MySQL control panel. Login with user "root" and the password you just set. To create a database, more info on that here: http://www.siteground.com/tutorials/...e_database.htm


When you've done all this, you need to edit the credentials of the "mysql_connect" function in your gamemode as has been told you before by the people above me.

Good luck.