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?
Heidi connects to database en Godaddy, but the user has no access
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!!
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!!
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.
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.
Please login to leave a reply, or register at first.