How to include the mysql header?

Question

I'm building an open source project from source,

and it needs to include <mysql.h>:

#if USE_MYSQL
#include <mysql.h>
#endif

and the compiler reports:

mysql.h no such file or directory

MySQL is yet another great open source project. What do I need to do to make it work?

Does `#include "mysql.h"` work? There are differences between including between `< >` and `" "` (depending on if the file is in the same directory as the code being compiled, or elsewhere - it's been a while for me and I forget the details, look it up). Also, what is the path to your MySQL source and is that path a part of your build path? — FrustratedWithFormsDesigner, Mar 25 '10 at 14:16

score 8 · Answer 1 · answered Mar 25 '10 at 14:19

8

This will be entirely dependent on your build methods, whether that's using an IDE like Visual Studio, Eclipse, etc, or if you're using shell scripts and command lines in *nix.

You will need to make sure that that file (mysql.h) exists in your 'includes' path.

For example, in Visual Studio, you would go into:

Project Properties -> Configuration Properties -> C/C++ -> General -> Additional Include Directories

And include the directory to which you have 'mysql.h' saved.

Then, for your linker properties, repeat the steps and include the respective DLL/LIB file path in your Additional Library Directories

This will differ greatly depending on your environment, so more information would be needed for exact step-by-steps. But this should explain the actual Problem.

answered Mar 25 '10 at 14:19

KevenK

2,975
3
26
33

I have neither `mysql.h` nor `mysql.lib`,where should I download it? – symfony Mar 25 '10 at 14:24
8

@symfony: EPIC FAIL XD How do you expect to include a file you don't have? – Federico klez Culloca Mar 25 '10 at 14:25
Is the libs included in the source download? – symfony Mar 25 '10 at 14:33
4

@symfony, you could download it and see. You're only ~20MB from finding out. – jball Mar 25 '10 at 15:25

score 7 · Answer 2 · answered Sep 20 '12 at 15:20

7

For me, on Ubuntu 12.04, I needed to use this include

#include <mysql/mysql.h>

answered Sep 20 '12 at 15:20

mrk

4,999
3
27
42

score 1 · Answer 3 · answered Apr 24 '13 at 09:40

1

g++ -o Programname $(mysql_config --cflags) Programfile.cpp $(mysql_config --libs)

Does the trick in Linux.

answered Apr 24 '13 at 09:40

JazzCat

4,243
1
26
40

score 1 · Answer 4 · answered Mar 25 '10 at 14:16

1

Did you try to give the include statement a full path to the file?

answered Mar 25 '10 at 14:16

proglammer

11
1

and when you have to change your development environment what will you do? – Federico klez Culloca Mar 25 '10 at 14:22
1

@klez: testing with the full path to the file *is* valid as a test to see if it work. Of course it shouldn't be left that way... – FrustratedWithFormsDesigner Mar 25 '10 at 14:32
@FrustratedWithFormsDesigner yes, that's what I meant :-) – Federico klez Culloca Mar 25 '10 at 14:35
Although full paths in `#include` directives are allowed, they are discouraged. A better practice is to add folders to the compiler's list and remove them from the `#include` directive. – Thomas Matthews Mar 25 '10 at 17:07
agreed with everyone! rephrased: "did you try to include the full path to the file just for test purposes, to see if the compiler tries to get the correct path?" – proglammer Sep 13 '10 at 07:27

score 1 · Answer 5 · answered Mar 25 '10 at 14:23

#include  "path-spec"
#include  <path-spec>

Both syntax forms cause replacement of that directive by the entire contents of the specified include file. The difference between the two forms is the order in which the preprocessor searches for header files when the path is incompletely specified.

#include "path-spec" instructs the preprocessor to look for include files in the same directory of the file that contains the #include statement, and then in the directories of any files that include (#include) that file. The preprocessor then searches along the path specified by the /I compiler option, then along paths specified by the INCLUDE environment variable.

#include <path-spec> instructs the preprocessor to search for include files first along the path specified by the /I compiler option, then, when compiling from the command line, along the path specified by the INCLUDE environment variable.

I don't know what compiler you are using, but it may require you to add your includes and libs to the compilation:

g++ bla.cpp -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient_r

Actually, it has nothing to do with the -I option -- unless you're on GCC. It'd be more correct to say it asks the compiler to look for the header, rather than using a relative path to the current file being compiled. So, -1 for not being completely correct, but +1 for getting the gist of the information the OP needs. — Billy ONeal, Mar 25 '10 at 14:27

How to include the mysql header?

5 Answers5

Linked

Related