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

having trouble connecting to godaddy MySql database

User, date Message
Written by spaceballone
1 year 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
1 year ago
4936 posts since Fri, 07 Apr 06
See here
Written by spaceballone
1 year 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
1 year ago
380 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
1 year 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
1 year ago
380 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
1 year 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
6 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
6 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.