windows如何安装mysql驱动程序,如何在Windows上安装MySQL c ++驱动程序

I had a question before because my code didnt work due to no mySQL driver being installed.

now i have downloaded the latest version of mysql and have qt 5.0.1 however the documentation on Qt or anything else i can find is just not right for 5.0.1 its showing all these dir paths that just arent in the 5.0.1 build and i cant find what to do to just install this driver

any help would be really good, im using windows 7 pro btw

thanks in advance

解决方案

First of all you need to find where you have installed mysql. I guess it would be somewhere in your Program Files. There you will see two directories: include and lib. If not - than you haven't installed the developer version of mysql. Don't worry, just run mysql installation once again, select updating your current install and be sure to check 'developer-something' in the wizard.

Now let's assume, you did everything right, and you found mysql include and lib directories. Remember them (we'll need them a bit later). Now you go to your Qt's directory, and find driver's sources somewhere there: ./Src/qtbase/src/plugins/sqldrivers/mysql.

Now do several steps:

Open cmd and proceed to mysql driver's source directory

Type qmake "INCLUDEPATH+=C:/MySQL/include" "LIBS+=C:/MySQL/lib/libmysql.lib" mysql.pro, where 'C:/MySQL/include' is your path to mysql's include and 'C:/MySQL/lib' is your path to mysql's lib.

Type nmake (or make if you're using mingw)

Type nmake install (or make install)

Add your mysql's lib path to your system PATH

Reboot

After that, everything should work fine.