Sign in to follow this  
dashe123

Database MTA

Recommended Posts

Can someone explain whats happening and how to fix that? BTW I'm new at making MTA server. :| I know there's something wrong with database but I can't figure out how to make it or edit it. I already tried http://wiki.multitheftauto.com/wiki/Mysql

[2011-07-30 00:34:56] ERROR: Unable to connect to mysql: (2003) Can't connect to MySQL server on 'localhost' (10061) 
[2011-07-30 00:34:56] ERROR: sql\mysql.lua:42: Connection to MySQL Failed. 
[2011-07-30 00:34:56] Server shutdown as requested by resource sql (MySQL failed to connect.) 
[2011-07-30 00:34:56] Start up of resource sql cancelled by script 
[2011-07-30 00:34:56] ERROR: Unable to start resource sql; Start up of resource cancelled by script 
  
[2011-07-30 00:34:56] Start up of resource irc cancelled by script 
[2011-07-30 00:34:56] ERROR: Unable to start resource irc; Start up of resource cancelled by script 
  
[2011-07-30 00:34:57] ERROR: Unable to connect to mysql: (2003) Can't connect to MySQL server on 'localhost' (10061) 
[2011-07-30 00:34:57] ERROR: sql\mysql.lua:42: Connection to MySQL Failed. 
[2011-07-30 00:34:57] Server shutdown as requested by resource sql (MySQL failed to connect.) 
[2011-07-30 00:34:57] Start up of resource sql cancelled by script 
[2011-07-30 00:34:57] ERROR: call: Failed, the resource sql isn't running [string "?"] 
[2011-07-30 00:34:57] Start up of resource players cancelled by script 
[2011-07-30 00:34:57] ERROR: Unable to start resource players; Start up of resource cancelled by script 
  
[2011-07-30 00:34:58] ERROR: Unable to connect to mysql: (2003) Can't connect to MySQL server on 'localhost' (10061) 
[2011-07-30 00:34:58] ERROR: sql\mysql.lua:42: Connection to MySQL Failed. 
[2011-07-30 00:34:58] Server shutdown as requested by resource sql (MySQL failed to connect.) 
[2011-07-30 00:34:58] Start up of resource sql cancelled by script 
[2011-07-30 00:34:58] ERROR: call: Failed, the resource sql isn't running [string "?"] 
[2011-07-30 00:34:58] ERROR: call: Failed, the resource sql isn't running [string "?"] 
[2011-07-30 00:34:58] Start up of resource vehicles cancelled by script 
[2011-07-30 00:34:58] ERROR: Unable to start resource vehicles; Start up of resource cancelled by script 

Share this post


Link to post

At the beginning i have the same problem, but I think it's the ports...

I'm not sure though.

Share this post


Link to post

Can anyone tell me more about MTA MySQL? Do I have to download MySQL installer or MTA already has some kind of database? How do I add tables and edit them? How do I edit MySQL password, user, database name, etc?

Share this post


Link to post

You have to own a website with MySQL

here's one:

http://www.000webhost.com/480103.html

This one has MySql and phpMyAdmin, and it's free.

In MySql you have to Create new database and user, after creating it, there's an Database name, username, host and password.

Put that in your script...

Then go to your phpMyAdmin (there's a link in the top), after when your in your phpMyAdmin

Share this post


Link to post

My friend told me about XAMPP. Maybe it's a better way to make database but when I tried it I didn't understand where can I edit tables, password,database name, etc.

Share this post


Link to post

Do you mean the XAMPP ?

I have it but i don't understand it.

I'll send screenshots to you how to get the Database, Username, Password and Host.

Share this post


Link to post

Or use sqlite which is free and built in, and generally fine for whatever you want...

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.