MySQL C API and XCode Settings

[Gregg Green]

Install MySQL binary from mysql.com

Run XCode and create new project

Edit Project Settings

Search Paths - Header Search Paths
/usr/local/mysql/include
$(inherited)

Search Paths - Library Search Paths
/usr/local/mysql/lib
$(inherited)

Linking - Other Linker Flags
-lmysqlclient
-lm
-lz
$(inherited)

main.h
#include <stdio.h>
#include <mysql.h>
MYSQL mysql;

main.c
#include "main.h"
int mysql_connection(){
mysql_init(&mysql);
if (!mysql_real_connect(&mysql, <host>, <user>, <pwd>, <database>, <port>, NULL, 0)){
// error
} else {
// success
}
return(0);
}