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

having trouble connecting to godaddy MySql database

User, date Message
Written by spaceballone
11 months ago
Category: General
4 posts since Sun, 02 Jun 13
Hi, I have a MySql database on godaddy and can't get HeidiSql 8 to connect. I'm using the ip address, username and password that show up on my PHPMyAdmin, so for example my admin page shows:

Server: 11.22.33.44 via TCP/IP
User: mylogin@11.22.33.44

I enter the same things in HeidiSQL (i've tried user with and without the "@11.22.33.44") and get the following error message:

SQL Error (2003) in statement #0: Can't connect to MySQL server on '11.22.33.44' (10060)

I've tried putting my credentials in the session manager and also prompting either way - no difference.

Also, I've checked and the port in HeidiSQL matches the port in my SQL System variables.
Written by ansgar
11 months ago
4789 posts since Fri, 07 Apr 06
See here
Written by spaceballone
11 months ago
4 posts since Sun, 02 Jun 13
I found that thread before I posted mine. My 'skip networking' system variable is off, but the 'hostname' system variable does not have a % anywhere in it. Here's what it sort of looks like:

p1nhmysq9999.xyz.1234.msp1.abcdefg.net

Where do I add the % sign? Beginning, end, or somewhere in the middle?

Also, how do I add it? I don't see an obvious way to edit the hostname in phpMyAdmin and I'm certainly not an expert in it..
Written by jfalchMoney, Euro
11 months ago
352 posts since Sat, 17 Oct 09
"Where do I add..." - you don´t.

The hostname, ie the name of the host that the mysql server is running on, is not supposed to have a % anywhere. furthermore, you can not change it with such a hoster.

% is only used in the "mysql" databases´ "host" permission table, in the "hostname" field (NOT identical or related to the system variable), as a wildcard, matching several or many real host names.

however, this is pretty secondary; the most important information is contained in the third post (@kalvaro) of the thread mentioned by ansgar above: "Most hosting services prevent outside access to their databases by default. Some prevent it in all cases. In GoDaddy it depends on whether you are a pay customer" - well, are you a GoDaddy pay customer ? if so, i suggest you ask their support on how to access your databases using heidisql.
Written by spaceballone
11 months ago
4 posts since Sun, 02 Jun 13
Ok, sorry I misunderstood the part about the % in that post.

I am a paying customer, so that's not an issue. From a little more time with google, it looks like I have to enable direct access and this can only be done when a database is newly set up. I don't remember if I did this or not when I set the database up.

I think I can re-create my DB again and enable it, but I've found some warnings about security if this is selected. How unsecure would I be? What's the worst case that would happen? I'm basically just using the DB to support comments/questions on a non wordpress website that I have so it's not like it's anything terribly important.
Written by jfalchMoney, Euro
11 months ago
352 posts since Sat, 17 Oct 09
you can dump out the current db contents with phpmyadmin to an .sql file, drop and re-create the database (with direct access), then reload the contents using heidisql. (nb: "@host" is nearly never part of a username)

then, for such a low-profile content, IMHO security implications are negligible. UNLESS you use the same access data (user/pass) on other, higher-impact systems (google, facebook accounts)...
Written by spaceballone
10 months ago
4 posts since Sun, 02 Jun 13
Ok, great. I will give it a try. Thanks for the help!
Written by tonygeorge87@gmail.com
3 months ago
2 posts since Wed, 22 Jan 14
simplw way to create database in godaddy http://hints.steptoinstall.com/add-create-mysql-database-user-godaddy-step-by-step-beginners.html
Written by tonygeorge87@gmail.com
3 months ago
2 posts since Wed, 22 Jan 14

tonygeorge87@gmail.com wrote: simple way to create database in godaddy http://hints.steptoinstall.com/add-create-mysql-database-user-godaddy-step-by-step-beginners.html[/quote]

 

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