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

[expired user #6156]'s profile image [expired user #6156] posted 12 years ago in Creating a connection Permalink
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?
ansgar's profile image ansgar posted 12 years ago Permalink
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`" ?
[expired user #6156]'s profile image [expired user #6156] posted 12 years ago Permalink
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!!
ansgar's profile image ansgar posted 12 years ago Permalink
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.
[expired user #6156]'s profile image [expired user #6156] posted 12 years ago Permalink
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.
ansgar's profile image ansgar posted 12 years ago Permalink
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.
[expired user #6156]'s profile image [expired user #6156] posted 12 years ago Permalink
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.
[expired user #6156]'s profile image [expired user #6156] posted 12 years ago Permalink
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.