How to set up MYSQL?
#1

I'd love to know how so I can run my trucking server. I am new to this whole samp thing so, don't be mean if the error code is an obvious fix.


Error Code:
[18:25:26] [MySQL] Error (0): Failed to connect. Can't connect to MySQL server on 'localhost' (10061).
[18:25:26] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'localhost' (10061).
[18:25:26] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'localhost' (10061).
[18:25:27] [MySQL] Error (0): Failed to connect. Can't connect to MySQL server on 'localhost' (10061).
[18:25:27]


Tell me if I need to include anymore.
Reply
#2

If home hosted: You need to download XXAMP and setup a MySQL database for the server to connect to.

if server hosted: Just setup a MySQL database and setup the config file to connect to it.

For both, just use *******/******.
Reply
#3

Then how do I make it so it connects to that MySQL Database? And I am using home hosted for the time being.
Reply
#4

Don't know how to set it up..
Reply
#5

Would love some help.
Reply
#6

I think there's a manual that comes with XAMPP that tells you exactly how to set it up. If not, use ******.
Reply
#7

http://dev.mysql.com/downloads/mysql/

I always use the original stuff when coding rather than one of these packages like XAMPP or WAMP or whatever else there is out there.

The first problem with your script will probably be that they have not given you any SQL files to setup the database, or if they have you will have to insert the SQL files into the database using one of many methods. So before even trying to get a database working, check the pwn script to see if there is either: "CREATE TABLE" OR an SQL file(s) with the gamemode.

If you have knowledge of databases, mysql or otherwise, this will be handy.

Every database has:

a username and password, default setup username is usually root (ALWAYS set a password) and is usually setup to connect to all databases within your local server (home hosted).

a database which will contain:
at least one table
each table has at least one field header(thats like a header column)
each tables fields should contain 1 row of data for you to see the information within it to be displayed
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)