Having trouble connecting.

hi,
When i try to connect to HeidiSQL it keeps giving me an error saying "SQL Error: Can't connect to MySQL server on '127.0.0.1'(10061)"
I am trying to use HeidiSQL for a Private WoW Server and so dont no hostname, User, or password. Does anyone know anything about it?

Thanks.

Did you read this:
http://www.heidisql.com/forum/viewtopic.php?t=247
sticky?

p.s. If you set up the server yourself, then you are the only one that can know things like a username. If you didn't do it yourself, you should talk to the person in charge

"Can't connect" means that there is most likely no server running at this host (127.0.0.1).

You will have to get your hostname, user and password. Nobody here will be able to tell you, but maybe a server administrator of your server.

ok, will give it a go.

thanks

ok, I got into the database I wanted but wheni tried to check the data on something it gave me a error:
"Access violation at address 005D30ED in module 'heidisql.exe'. write of address 000000FC"
does anyone know what this means?

Which version of HeidiSQL are you using?

Could be that you don't have the needed privileges to SELECT table data.

I have heidisql 3.0 installed at the moment.

Bah! i seem to get error after error :? after reinstalling heidisql 3.0 and then trying to get into the items data i get another error:
"SQL Error: 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 'Unique LIKE '%17182%' OR maxcount LIKE '%17182%' O */
any ideas?
thanks

UNIQUE is a reserved word in MySQL and you are using it for a column name if I interprete that correct. You can quote column names using backticks to avoid this type of error:

`Unique` LIKE '%17182%' OR `maxcount` LIKE '%17182%

That was SQL code which you wrote yourself or did HeidiSQL generate it after using the "Search"-box?

Which MySQL version is installed on that server? You can check that on the "Host" tab. I have a feeling that this a pre 3.23 server or so (released in 1999 or 2000). If yes, you will run into more and more errors in the future and the server should be upgraded.