how to use heidisql... to make a wep and connect

[russellx1]

It says unkown column name 2 in field list?

[CRM187]

I cant get the world tab

[Chris0943]

I have no clue why this is, but in my heidisql there is no world tab! i have everything open (mysql, logon-server, and the world) btw im using arcemu. please help

[SirFrappo]

@Chris0943 I'm having a similar problem. Seems it a rare one, because whenever it comes up, everyone's clueless on how to fix it.

[R0YA1SH07]

@Chris0943 Did you ever fix it?

[Supmahify]

It comes a error that says  somenting with name2!!!! HELP ME!

[TheBloodRevolution]

wen i do it , i load up the file and i press f9 (execute) and then it accepts it , and it goes into the database , then i close mysql and heidisql and re open all my server programs , but then wen i go in game i type in the entry id and it says : item 77777 is not a valid item ! , please help , and btw i have tried all the batch files :(

[Roy1203Cool]

OMG . TY! IT WROKED TY!!! LOVE YOU!

[Gelmarak]

i cant connect (error) cant connect to 127.0.0.1????

[boby00001]

k well what your telling me is you can't connect to your own computer so im gona say you fucked up

[snubben76]

@Gelmarak You have to start mySQL.bat first.

[7tusan]

you eather have root or ascent as passwod

[harismahmood1234]

whats better mangos arcemu?

[boby00001]

arcemu is easier to design your own way but mangos comes with like 90% of the bosses already scripted

[RaxiCax]

ManGos are hard to understand i can't understand it :D i use arcemu! :D

[Frostwhisper1]

it does not work. i use mangos, is it the same for mangos?

[boby00001]

just dl the mangos versrion

[razormunch642]

ty so much

[MucanDusa]

THANK YOU SO FUCKIN MUCH!?!?!?!?!

Spent nearly 2 hours trying to solve this with other peoples help no one else had the "Heres how to find your username and password for Heidisql" section thanks a lot man.

[boby00001]

@MucanDusa ya i put that in just because i know i had a hard time trying to find that out myself and i knew people would love to have it

[wimixxe]

How to delete SQL in heidiSQL pm me plz or reply or i cant see it xD

[raider3460]

i dont have a config folder lol how do i get one?

(when i made my server i only used the ad.exe thing and not the dbc extractor.exe)

maby i better use the dbc extractor

[raider3460]

whats the password then?

i use an arcemu 3.2.2a server

[boby00001]

watch the video and find out thanks

[raider3460]

hey why dosent my HeidiSQL work it says "access denied for user 'root'@'localhost'

(using password yes)"

[boby00001]

your using the wrong password

[PureDarkAngelSkillz]

exactly what mine says and some other peoples say. (SQL Error: Unknown column 'name2' in 'field list'

[boby00001]

i would help you out if the answer wasn't already in the movie

[kghj9]

Can somebody help me with this error?

When i want to excute something thats pop up==

"SQL Error: Column count doesn't match value count at row 1"

Do someone know how to fiks?

[boby00001]

@stoulnn you really gota give me more info then that....

[NEWBSPANKER]

ya same for me i click f9 and it says error on column2 field list

[bloodangel95]

when I try to loggin to heidisql i get the error message:" could not establish connection! Details: SQL error: cant connect to mysql". Plz help

[darkqueen47]

were do i get tha ip number from

[tinny120]

i think i llove you

[jacetbiddle]

where is the thing that tells u ur password also??

[jacetbiddle]

how to i get to the control pannel???

[tjejgalen]

Okey, Fixed it but the database foler isn't there

[tjejgalen]

It stands i can't connect to MySQL Server

[sirnathan]

The section beginning at 1:29 was all I needed... thank you!!! This has been so damn frustrating because every guide assumes that "root" is also the password... so I never could get it to work until now. Thank you!!!!

[BannaricSmellz]

This guyz gotta BADASS LISP XDDDD

[Proz428]

AHHH when u fucking say some word with s u whistle-.-

[PGuapo912]

ur mic sucks ass

[sk8bodom]

i got the program to open i typed in root for password and login and i got the item to show up but unlike in this vid in my HeidiSQL there was no arcemu tab to click on my server was running at the time can someone help me plz?

[DeathJr17]

for me heidisql isnt connected to any database, how do i connect it to mine?

[raco95]

LOOK---- If it telss Error Cant connect to MySQL  YOU MUST GET YOUR SERVER UP FRIST.. Ones you get your server up and running it will work!, Hope it helps =)

[joepdekleine]

i dont understand where to put the weapon i cant find the "weapon" file so i dont know where to safe the weapon

[Kuppex]

i got This Problem : '' Coult Not Establich Connection! Details:

SQL Error: Can't Connect To MySQL Server On '127.0.0.1' (10061)''

PLS REPLY!

[davyitup1]

yo, i think u need to run your wow server and then try connecting

[kevann113]

uhm when i try to execute it it says "SQL error in column bla bla :p

[grayspar]

mine says : Error : Host 'jonny-Pc' is not allowed to connect to this mySQL server.... helppp, its my own server, with the IP 5.171.238.78

[biggerstaff1]

on last step and it says error

[RyAn639OnXbOxLiVe]

it says i cant connect Ryan-pc is not allowed?????

[ZhoopDaWhoop]

thanks ^_^ really helped me :)

5/5

[kristifp1]

I cannot connect to HeidiSQL with tha info. >:(

[HavardOnNetwork]

PLZ HELP ME WITH THIS FAST!

When i try to connect it says " Could not establish connection! Details: SQL error: cant connect to MySQL server on 127.0.0.1 (10061)"

...

[Najs1one]

try to start the database in ur arc emu fodler

[warbear1993]

confuzzled, okay, im half way through this, i cant connect to the arcemu database... it just says "edit server variable"

how do i get past that?

[D444n11]

Thanks mate xD

Turn Volume up to 100 to hear him.....

[o7uk]

this freaking sucked. couldnt even hear what you were saying and didnt understand a shit!

[christianguy921]

i can spawn my wepeon but it says its pants, and its not displaying right, its just the white and blue checkered box.

[christianguy921]

and it says its pants so i cant attack with it

[Killclaw4000]

should i be running mySQL while I'm connecting to heidiSQL?

[Killclaw4000]

I haqve a hamachi IP adress.

A. There is a error when i connect to HeidiSQL.

B. Where do i put my hamachi IP adress in ArcEmu?

[Jackazzza]

A. Don't use Hamachi's IP, when you need to connect to HeidiSQL the IP that is needed is 127.0.0.1 that is your own pc :)

B. ahh i don't really rember, i'll look it up ;)

[Deathgod1221]

Hey, is there anyway to connect to another person hedisql server?

[shootmepleez669]

hes not helping my volume is all the way up and i cant hear him

[pubay]

My server is on hamachi, and should I use my hamachi IP? or my 127.0.0.1?

[boby00001]

you use your 127.0.0.1 to connect to it if you try to connect to some one elses then you use there ip but it its yours use 127.0.0.1

[dkane2000]

dude u own thanks :D

[boby00001]

lol np :P i do what i can to help

[grandorder1]

mine cam up a error it says i cant connect to 127.0.0.1

[sharpndagger]

what is wrong everytime i try to make it i get this "/* SQL Error: Unknown column 'mountdisplayid' in 'field list' */" can u please help

[Xandero0]

me too very anoying -.-

[indyllllll09]

where arcamu i dont have it can u help

[boby00001]

it may be called "world" instead of arcemu

[mrnicknily]

very very good work man!

[boby00001]

thanks man :D

[Hibtwa91]

I dont have the AcrEmu side click thing is it in something alse like world please help

[boby00001]

ya with different repacks its gona be called different things i think that it will be in your world thing

[stackkarn]

lol cant find wepons :O

[stackkarn]

nvm fixed it

[stackkarn]

good vid but i did exacly the same as u but it came up SQL Error: Access Denied for users "root"@localhost" (using password: NO)

[torajonna]

nice vid .D but how will i get the wep on wow like the when the wep spawn is number 14 but where shall i write it please answer me fast

[boby00001]

you go ingame and if you put the entry ID as 14 and you did every thing right type in .add 14 or .char add 14 also if you didn't restart the server you have to do that or if your repack has the command type in game this .server reload items

[TehBloodyBrit]

i keep getting this error message saying "1130-'localhost' is not allowed to connect to the MySQL"

How do i fix this? :S

[boby00001]

is your MY SQL up?

[wiidude45]

TALK LOUDER but good vid

[maxeyrock6]

why is it deleted?

[boby00001]

for some reason youtube stops showing this vid like every other day for no reason lol

[khooltool]

You r amazing

[boby00001]

lol thanks :D

[tauren224]

Hey, it's WoWemuGM, what program did u use to film this?

[boby00001]

oh i used snagit 9

[dotcomixproductions]

i cant logon with the User=root and password=root. with hostname 127.0.0.1

I get error "Sql Error: Can't connect to mysql server on 127.0.0.1' (10061)"

[coolguyV5]

after i had it installed and everything i tried to login with root as username and password but when its logged in and everything it doesnt show any tables

[boby00001]

ok umm then one of ur files are prob messed up and u dont have a data base so u have to install one or redownload the repack... if the repack does not have a data base then your gona have to get a new repack

[coolguyV5]

but the thing is that when i use navicat it shows the tables

[coolguyV5]

ok nvm i fixed it

[GM1M35R3P3R]

PS: i made it now its working :D

[GM1M35R3P3R]

hi i pls help me when i open heidisql and hit connect it appear this error "Could not establish connection! Details:

SQL Error: Can't connect to MySQL server on '127.0.0.1' (10061) " if you could help me pls tell me what to do

[sssdws]

im having a problem i hit F9 and i get this error "/* SQL Error: Unknown column 'name' in 'field list'" i have no idea what to do

[boby00001]

ok all u have to do is select the right database on the side so select the thing that has the items file in it usually the world database..

[believer06]

Hello. Is there a way to edit NPCs with Heidi? Ive been on some servers where they had the guards dancing and saying things (in text). Thanks, Great job on the vids, btw. Very helpful.

[noogaixXx]

but were is that... folder for the world.conf thing..

is it on :c/Panex Public 6.4/server/configs/arcemu-worl­d?? i dont know..

[boby00001]

ya thats the file ur looking for

[noogaixXx]

lol i dont know.. i was loking for how i can make a realm.. to my privatserver :P

how do i do that ?

[boby00001]

no ok go to ur world file in ur configs folder and look there it says ur pass there

[noogaixXx]

pass.. like... ur licens or?

[HugMySwordFTW]

i still cant connect!

so it

User: root

Password: root

and it should connect?

[xXDevilfahadXx]

u can use it like navicat8?

coz i deleted emportant file and now it's stuck , so i'm trying to make maple story with heidisql o.O

[boby00001]

ya np guys keep sendimg me messages or posting

[MystikalDemon]

Thanks man helped a lot

[Genesis000000]

thank you

[boby00001]

k u gota first go to right data base so if ur making a vendor and using my repack or most repack go to arcemu and scroll down to vendors when ur there make sure that all the first ones are like a 2 or something that hasnt been use i recomend starting at 40000 or like 50000

[noogaixXx]

ok.. but.. to get to arcemu and to vendor.. u need to loog in on that.. heidiql and i cant freaking log in :P

that is my problem.. and.. i dont realy undrastand... every thin u was saying.... bot how do i use the repack?? :P i have only playing wow for a short time.. :P i know how to get on a funserver/privateserver :P but i need help to make the realm that i can log into on my privateserver.. thx

[GMelemntal]

ok i hit F9 it said this "1 Rows affected,0 Fields, 0 records in last result set. Query time0.047 sec." then i open up back and world and logonserver type reload right then i go in and type .additem 900009 and it says it's not a valid item