{"id":141,"date":"2011-03-20T17:16:39","date_gmt":"2011-03-20T15:16:39","guid":{"rendered":"https:\/\/www.npcglib.org\/~stathis\/blog\/?p=141"},"modified":"2014-01-11T22:17:29","modified_gmt":"2014-01-11T20:17:29","slug":"compile-qt-with-mysql-support-on-windows","status":"publish","type":"post","link":"https:\/\/www.npcglib.org\/~stathis\/blog\/2011\/03\/20\/compile-qt-with-mysql-support-on-windows\/","title":{"rendered":"Compile Qt with MySQL support on Windows"},"content":{"rendered":"

Qt on windows does not compile with MySQL support out of the box. If you’re unsure how to compile Qt on Windows with Visual Studio take a look at my other post on how to create a Qt Shadow build with Visual Studio<\/a>. Based on the setup explained there, you have to first download the MySQL server<\/a>. I recommend using the zipped pre-compiled binary releases (such as mysql-5.x.x-win32.zip<\/code>), otherwise you’ll have the burden to compile MySQL yourself too. Decompress this into a directory of your choice, e.g. D:\\dev\\mysql<\/code>.<\/p>\n

Now, when you configure your Qt build, add the appropriate options shown coloured below:<\/p>\n

configure -ltcg -opensource -mp -qt-sql-mysql -I D:\\dev\\mysql\\include -L D:\\dev\\mysql\\lib -l libmysql<\/span><\/p><\/blockquote>\n

You should see the Qt configuration output mentioning MySQL support. Follow the subsequent steps outlined in my [intlink id=”54″ type=”post”]other post[\/intlink] to compile Qt and if everything is setup properly, you will end up with a Qt version that supports MySQL via QSql.<\/p>\n

Software used<\/h3>\n

(versions here are updated each time I update the toolset and libraries)<\/p>\n