Windows MySql problem and a Questions

[witze15]

good evening,

also at first i become a message when i start the server when i turn mysql on...
i already have xampp installed (because i programming in PHP), than i have create a new database called Tibia, and have change this in the config:

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "MYPASSWORD"
mysqlDatabase = "tibia"
mysqlPort = 3306

now i start the server an get this error:
[12/03/2013 22:15:10] >> Loading database driver...Failed to connect to database. MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061)
[12/03/2013 22:15:12] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SQLite which doesn't require any connection.

now is the question: why? i have importet the SQL and have change sqllite to mysql.
And Xampp is started.

i hope you can help me there.


Now i have one question.
where i can get more / all NPC's? also like bank, seller, buyer etc. also the standards from rockguard ^^


now i hope you can help me..


bye,
Daniel

PS.: Sorry for this (bad) english xDD

 

[Bouczas]

Hmm, at first go to phpmyadmin > click Users on table and look on your root, on the right from your root u will see HOST it should be localhost btw sometimes it's 127.0.0.1. If it's localhost dont touch anything but If it's 127.0.0.1 change your mysqlHost from config to 127.0.0.1 .
It could be wrong password, create new database with small T, np. in phpmyadmin small "tibia" and this same in your config.

 

[witze15]

Also i will try it now, but after installed the server my PC is laggy so much >.<
Its like an virus...

i know that the antivirus tell me that i had a virus after this program, but why i had problems now?! -.-

i save the server now and scan the system i hope that it will be back to the normal.. ^^

after this i'm try this Thanks


And the question for the NPC's,
Where i can get this all? also npc's i dont need all, but what i need is the system like bank, quest, shopper, and vocationsseller (also when i vocation sorcerer i can only buy by sorcerer seller ) and the oracle

where i can find that?

Thanks,
daniel

 

[Mesmeroo]

About the npc's, you can download a datapack from the Downloads section and see if the npc's that you required are in that pack.

 

[witze15]

thanks,

and a another problem also now i'm on mysql,
but i write the register / login code, thats okay but the account create there is a error message and i dont know why..

Cannot add or update a child row: a foreign key constraint fails (`tba`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE)

im only use INSERT INTO PLayers the tables vocations, name, account_id and sex..