mysql h file can t be found

Question

i m trying to install connection between c   and mysql in ubuntu 12 04  i ve installed mysql-client  mysql-server  libmysqlclient15-dev  libmysql  -dev  but when i try to compile the code i got the error  mysql h there is no such file  i looked in the folders  there is mysql h file  i can t understand why it can t find it  here is my code       Simple C program that connects to MySQL Database server        include  lt mysql h gt       include  lt stdio h gt       main           MYSQL  conn        MYSQL RES  res        MYSQL ROW row         char  server    localhost         char  user    root           set the password for mysql server here       char  password                   set me first          char  database    Real flights          conn   mysql init NULL             Connect to database          if   mysql real connect conn  server              user  password  database  0  NULL  0               fprintf stderr    s n   mysql error conn              exit 1                     send SQL query          if  mysql query conn   show tables                fprintf stderr    s n   mysql error conn              exit 1                  res   mysql use result conn             output table name          printf  MySQL Tables in mysql database  n          while   row   mysql fetch row res      NULL            printf   s  n   row 0              close connection          mysql free result res         mysql close conn           it s worked  but now i m facing another error like    mysql c  In function    main     mysql c 21  warning  incompatible implicit declaration of built-in function    exit    mysql c 27  warning  incompatible implicit declaration of built-in function    exit     tmp ccinQBp8 o  In function  main   mysql c   text 0x3e   undefined reference to  mysql init  mysql c   text 0x5e   undefined reference to  mysql real connect  mysql c   text 0x70   undefined reference to  mysql error  mysql c   text 0xa5   undefined reference to  mysql query  mysql c   text 0xb7   undefined reference to  mysql error  mysql c   text 0xe7   undefined reference to  mysql use result  mysql c   text 0x11c   undefined reference to  mysql fetch row  mysql c   text 0x133   undefined reference to  mysql free result  mysql c   text 0x141   undefined reference to  mysql close  collect2  ld returned 1 exit status

User · Answer

You probably don t included the path to mysql headers  which can be found at  usr include mysql  on several unix systems I think  See this post  it may be helpfull   By the way  related with the question of that guy above  about syntastic configuration  One can add the following to your    vimrc   let b syntastic c cflags    -I usr include mysql    and you can always check the wiki page of the developers on github  Enjoy

User · Answer

just use     apt-get install libmysqlclient-dev    which will automatically pull the latest libmysqlclient18-dev  I have seen older versions of libmysqlclient-dev  like 15  puts the mysql h in weird locations e g   usr local include etc    otherwise  just do a     find  usr  -name  mysql h     and put the folder path of your mysql h with -I flag in your make file  Not clean but will work

User · Answer

This worked for me yum install mysql  It will install mysql client and then pip install mysqlclient

User · Answer

The mysql h file from the libmysqlclient-dev Ubuntu package is located at  usr include mysql mysql h   This is not a standard search path for compilers  however  usr include is   You d typically use the mysql h header in your code like this    include  lt mysql mysql h gt    If you don t want to specify the directory offset in your source  you can pass the -I flag to gcc  If that s what you are using  to specify an additional include search directory  and then you wouldn t need to change your existing code   eg   gcc -I usr include mysql

User · Answer

I think you can try this gcc -I usr include mysql   c -L usr lib mysql -lmysqlclient -o

User · Answer

For those who are using Eclipse IDE    After installing the full MySQL together with mysql client and mysql server and any mysql dev libraries    You will need to tell Eclipse IDE about the following   Where to find mysql h Where to find libmysqlclient library The path to search for libmysqlclient library   Here is how you go about it   To Add mysql h   1  GCC C Compiler -  Includes -  Include paths -l  then click   and add path to your mysql h In my case it was  usr include mysql    To add mysqlclient library and search path to where mysqlclient library see steps 3 and 4   2  GCC C Linker -  Libraries -  Libraries -l  then click   and add mysqlcient     3  GCC C Linker -  Libraries -  Library search path  -L  then click   and add search path to mysqlcient  In my case it was  usr lib64 mysql because I am using a 64 bit Linux OS and a 64 bit MySQL Database    Otherwise  if you are using a 32 bit Linux OS   you may find that it is found at  usr lib mysql

User · Answer

For CentOS RHEL   yum install mysql-devel -y

User · Answer

You have to let the compiler know where the mysql h file can be found  This can be done by giving the path to the header before compiling  In IDEs you have a setting where you can give these paths   This link gives you more info on what options to use while compiling   To your second problem You need to link the libraries  The linker needs to know where the library files are which has the implementation for the mysql functions that you use   This link gives you more info on how to link libraries

User · Answer

this worked for me    gcc dbconnect c -o dbconnect -lmysqlclient     dbconnect   -lmysqlclient is must   and i would personally recommend to use following notation instead of using -I compilation flag    include  lt mysql mysql h gt

[c++] mysql.h file can't be found

Examples related to c++

Examples related to mysql

Examples related to ubuntu-12.04

Examples related to mysql-connector