MySQL connection errors

[Abbeh]

Hey,

As the title clearly states, I cannot connect to the SQL DB for some reason. This has never happened before, but now I have made a few modifications to my folder and there we go.
Does anyone have a quick step-to-step on what to do to make the serverfolder connected to the SQL DB? I've seen someone else make the entire setup, but everything cannot be remembered.
1. I have MySQL open and it's running with Xampp.
2. I can access 127.0.0.1/phpmyadmin/ - And I can access my website through 127.0.0.1 as well.
3. The server won't start because of this issue.

Cheers buddies!

 

[Pitufo™]

Wrong password, database name or username in config.lua?

- - - Updated - - -

Or instead of using localhost as ip in config.lua use 127.0.0.1

 

[Abbeh]

Seems to be working now when I changed what you said..
But now, as the deranged person I am, I removed "Knight Sample" and the other samples, now I cannot create any characters.. Any solution for this while I have you on the line? ^^

 

[Vikarious]

If you have all files from your website you can import samples back from the db provided with the instalation of website.

Edit: You can try this:

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(2, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140508, 16777343, 1, 0, 0, 0, '', 1258140521, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258212752, 16777343, 1, 0, 0, 0, '', 1258212822, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140858, 16777343, 1, 0, 0, 0, '', 1258140885, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140912, 16777343, 1, 0, 0, 0, '', 1258140945, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 107, 114, 59, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140886, 16777343, 1, 0, 0, 0, '', 1258140910, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),

Import this, log on them and add what items you like.

It should work, but test it first. Use SQL console thing to import this.

 

[Abbeh]

If you have all files from your website you can import samples back from the db provided with the instalation of website.

Edit: You can try this:

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(2, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140508, 16777343, 1, 0, 0, 0, '', 1258140521, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258212752, 16777343, 1, 0, 0, 0, '', 1258212822, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140858, 16777343, 1, 0, 0, 0, '', 1258140885, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140912, 16777343, 1, 0, 0, 0, '', 1258140945, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 107, 114, 59, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140886, 16777343, 1, 0, 0, 0, '', 1258140910, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),

Import this, log on them and add what items you like.

It should work, but test it first. Use SQL console thing to import this.

Ah didn't think of that, thanks for the code buddy

- - - Updated - - -

I tried the code, but there comes up an error saying:

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7"

Anyone has any clue?