I have just installed Quantum GIS 1.8.0 on my Ubuntu 10. I want to add a MySql table as a data source but I can't see any options for connecting to mysql.

Can any one guide me how to connect to mysql?

N.B : Options for Available Database Types in Qgis are MSSQL,ODBC,PostgreSQL and ESRI Personal GEO Database.

  • no,It's not duplicate,that post for whome ,user can see mysql option in adding vactor layerlink,In my case I can't see option for mysql :( – Smit Shah Jan 7 '13 at 10:31
  • I'm sorry for being wrong. i have deleted dublicated message. – Aragon Jan 7 '13 at 11:01

You can try installing the package libmysql. I configured a vm with ubuntu 10.04 and after installing libmysql (it came with mysql-client) it works properly.

Try it and post here your results.

  • I had already loaded mysql-client,I Know that without mysql-client we can't make connection from qgis,now I has loaded eVis Plugin which use for mysql connection but following error occur "New Database connection requested... Connection to [localhost.test_db] failed: Driver not loaded Driver not loaded" – Smit Shah Jan 8 '13 at 5:44
  • Did you already reinstall mysql-client and qgis? Try to completely remove mysql-client and qgis (purge and delete paths) before reinstalling. And about others dbs? Did you try to connect with them? – José Filipe Lyra Jan 8 '13 at 14:23
  • yes , I had completely removed qgis and msql-client then I had install again ,I have no any other database,I work with only MySql db. – Smit Shah Jan 9 '13 at 5:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.