Hi Moojan Kh, to use the databasde created by phpmyadmin, you need the
mysql driver for jdbc and have the permission to connect from another
host outside the net than db server run. When you have this
requirements, you need to configure the datasource as mysql db, and go on
you have to download the jar file from the mysql dev and keep it at ur machine then u have to set up the datasource for the report you are going to design there u will see the manage drivers tab onclicking on this tab a window will be opened there u will see two tabs one is jar files and other is driver. click on the jar files u will see there add link click on it and upload the mysql jar file from the location you have kept and then click ok now you have mysql database driver integrated with birt.
now select your driver class which in my case is "com.mysql.jdbc.driver(v5.1)"
now proive the database url which is in mycase "jdbc:mysql://localhost:3306/db name"
now provide the user name which is ur phpmyadmin username
now provide the password which is ur phpmyadmin passowrd
u have successfully integrated your mysql db with birt