Hi, if you are using Ubuntu linux just type this message below:
sudo apt-get install mysql-server
sudo apt-get install libmysql-dev
And after, create an file with extention ā.cā and put this code into the file:
#include <stdio.h>
#include <mysql/mysql.h>
void main(void) {
MYSQL connection;
mysql_init(&connection);
if (mysql_real_connect(&connection, "hostname", "user", "password", "database", 1, NULL, 0)) {
printf("Yes! Connected\n");
mysql_close(&connection);
} else {
printf("Fail!\n");
printf("Error %d : %s\n", mysql_errno(&connection), mysql_error(&connection));
}
}
When you compile it, you may put some variables. You have to use the command line below:
gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
Have fun! :)
<< All Posts
Previous post:
Using postgresql in C programs for Linux
Using postgresql in C programs for Linux