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

Heidi connects to database en Godaddy, but the user has no access

User, date Message
Written by latin944
3 years ago
Category: Creating a connection
6 posts since Thu, 12 Jan 12
I created a webhosting acount in Godaddy. Phpadmin connects well to the database, and the user can work.

Heidsql DOES connect to the database through hostname + use + password + database, it shows the database, but not the tables. When clicking on the database name an error occurs:
/* SQL Error: Access denied for user 'xyz'@'%' to database 'abc' */. Why would a user be blocked? Is that a HeidSQL problem or a Godaddy problem?
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
Privileges are managed on the server, you need more privileges on that database. You could also paste here what goes right before that SQL error, I guess it's a "USE `abc`" ?
Written by latin944
3 years ago
6 posts since Thu, 12 Jan 12
There is nothing before. Just the error-message as a pop-up during establishing connection, indicating the access denied for the user.

I also guessed I or the user need more privileges, but which ones?

With cpanel on servers I am used to introduce the % wildcard for database access and that make Heidi work. In this case Godaddy claims that the database was confirgured for 'external access'. So something is wrong with some privileges, but which ones? Thanks in advance!!
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
You said "When clicking on the database name an error occurs". So, what do you see in the SQL history at the bottom? There is not just the error, there must be some USE ... query, and probably more. Please paste here.
Written by latin944
3 years ago
6 posts since Thu, 12 Jan 12
Perhaps ther is history, I see only line 8, and no options to scroll back (as far as I can see). I send you an email with 3 screen shots.
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
Man, your screenshots reveal you are using some superold HeidiSQL version - is that the 3.0 release? You need to update to the latest build before reporting errors.
Written by latin944
3 years ago
6 posts since Thu, 12 Jan 12
You're right! I'm now downloading and trying version 6.
But take the following as a nice compliment:
- Most software packages are full of bugs and problems and downloading the latest versions still give problems. (don't even mention Windows)
- I've been using my Heidisql 3 version with so much satisfaction for what I needed , that it simply not OCCURRED to me to download a newer version. Good for you.
Will let you know whether V6 has the same problem.
Written by latin944
3 years ago
6 posts since Thu, 12 Jan 12
And YES the godaddy conection works with Heidisql 6.

Thanks a lot and congratulations with this excellent program!!
 

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