distal-attribute
distal-attribute
distal-attribute
distal-attribute

Having trouble connecting.

nova posted 7 years ago in Creating a connection
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.
siMKin posted 7 years ago
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
ansgar posted 7 years ago
"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.
nova posted 7 years ago
ok, will give it a go.

thanks
nova posted 7 years ago
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?

ansgar posted 7 years ago
Which version of HeidiSQL are you using?

Could be that you don't have the needed privileges to SELECT table data.
nova posted 7 years ago
I have heidisql 3.0 installed at the moment.
nova posted 7 years ago
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
ansgar posted 7 years ago
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.

Please login to leave a reply, or register at first.