CODEWITHSUNDEEP
mysqlqgis
Smit Shah
Smit Shah

Reputation: 344

mysql connection in qgis

I had just install Quantum GIS 1.8.0 on my Ubuntu 10 ,I Want To Add MySql Table as Source but No Options for connecting to mysql can Any One Guide me how to connect to mysql?

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

Upvotes: 1

Views: 15649

Answers (1)

Julian Bogdani
Julian Bogdani

Reputation: 399

To add a MySQL data table or vector layer just follow the procedure of adding a new vector layer:

Menu Layer > Add Vector Layer

Select Database as source type. Then you have to define a connection by clicking on New.

Type: Mysql
Name: your connection name
Host: remote or local IP address
Database: database name
Port: leave blank for default 3306
Username: mysql user
Password: mysql user's password

Click on Test connection to check if everything works fine, then OK. Your connection is saved and you are ready to use it: Select it from the drop down menu and click on Open.

enter image description here

Hope this helps

Upvotes: 5

Related Questions