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

Having trouble connecting.

User, date Message
Written by nova
7 years ago
Category: Creating a connection
5 posts since Thu, 26 Jul 07
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.
Written by siMKin
7 years ago
104 posts since Sun, 01 Apr 07
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
Written by ansgar
7 years ago
5051 posts since Fri, 07 Apr 06
"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.
Written by nova
7 years ago
5 posts since Thu, 26 Jul 07
ok, will give it a go.

thanks
Written by nova
7 years ago
5 posts since Thu, 26 Jul 07
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?
Written by ansgar
7 years ago
5051 posts since Fri, 07 Apr 06
Which version of HeidiSQL are you using?

Could be that you don't have the needed privileges to SELECT table data.
Written by nova
7 years ago
5 posts since Thu, 26 Jul 07
I have heidisql 3.0 installed at the moment.
Written by nova
7 years ago
5 posts since Thu, 26 Jul 07
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
Written by ansgar
7 years ago
5051 posts since Fri, 07 Apr 06
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.