Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm trying to create a new vector layer and store it in a MySql-database, but when I test the connection I get an error with no detailed information at all. If I give an erroneus password I get a message that says:

MySQL connect failed for: db_qgisgeodata,host=localhost,port=3306,user=xxxx,password=ppppppp Access denied for user 'uuuu'@'localhost' (using password: YES)

Because I get a detailed error message if i give the wrong login credentials I think QGIS is able to connect to the database, but there is something more to it.

The user has full permissions on the database. The problem is the same if I try with the root-user.

  1. The user has full permissions on the database. The problem is the same if I try with the root-user.
  2. The database is empty.
  3. Windows 7x64
  4. QGIS 1.8.0
  5. MySql 5.5.28
  6. it's no problem to connect with the database from other applications.

I guess I'm missing something quite obvious here, but I can't figure out what. Any ideas anyone?

share|improve this question

closed as not a real question by Devdatta Tengshe, whuber Feb 15 '13 at 16:07

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
What exactly happens if you connect with the correct passowrd? –  underdark Nov 6 '12 at 12:45
    
I get a message with detaild error information that is empty. –  P-A Lindkvist Dec 7 '12 at 14:02

Browse other questions tagged or ask your own question.