Database MTA

[dashe123]

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 https://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 

[Jaysds1]

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

I'm not sure though.

[dashe123]

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?

[Jaysds1]

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

[dashe123]

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.

[Jaysds1]

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.

[qaisjp]

Take a look @ this tutorial, it'll help you a little.

https://forum.multitheftauto.com/viewtopic.php?f=108&t=34686

[Jaysds1]

Thanks for the tutorial...

[eAi]

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