Hi,

When I am trying to compile simple TEST.CC program I am getting the mysql_connect error. Can anybody tell what the error is.

The code for test.cc is:

#include <iostream>
#include <fstream>
#include <string>
#include <iomanip.h>
#include <sstream>

#include "mysql/mysql.h"
#include "handling.h"
#include "utils.h"
#include "storage.h"
#include "parser.h"
#include "update.h"
#include "unp.h"
#include "readwrite.h"



using namespace std;


MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;

const unsigned ASM_ADDR = 0xe0000000;
const unsigned ASM_MASK = 4;
const unsigned SSM_ADDR = 0xe8000000;
const unsigned SSM_MASK = 8;

bool CreateDatabase() {
//Connection to mysql server
if (mysql_connect(&mysql,NULL,"root","xxxxx") == NULL) {
cout << "Error: Couldn't connect to mysql server.";
return false;
}
cout << "Database created successfully." << endl;
return true;
}


The error is :

root@xxx-laptop:/home/xx/Desktop/xxx# g++ -ansi -pedantic -Wall -W test.cc
In file included from /usr/lib/gcc/i486-linux-gnu/4.1.2/../../../../include/c++/4.1.2/backward/iomanip.h:31,
from test.cc:4:
/usr/lib/gcc/i486-linux-gnu/4.1.2/../../../../include/c++/4.1.2/backward/backward_warning.h:32:2: warning: #warning This file includes at least one deprecated or antiquated header. Please consider using one of the 32 headers found in section 17.4.1.2 of the C++ standard. Examples include substituting the <X> header for the <X.h> header for C++ includes, or <iostream> instead of the deprecated header <iostream.h>. To disable this warning use -Wno-deprecated.
test.cc: In function ‘bool CreateDatabase()’:
test.cc:31: error: ‘mysql_connect’ was not declared in this scope
root@xxx-laptop:/home/xx/Desktop/xxx#

It tells mysql_connect is not declared in this scope.

thanks.

well you aren't ilnking it to libmysql are you? how is suppopsd to find these libraries? try adding -lmysqlclient. also probably need to define the library directory, -L/usr/local/lib/mysql assuming that is the right location.

Could you please tell in detail how to do this

Even when I tried to compile this with lmysqlclient, again it shows the same error.

g++ -ansi -pedantic -Wall -W -lmysqlclient test.cc
In file included from /usr/lib/gcc/i486-linux-gnu/4.1.2/../../../../include/c++/4.1.2/backward/iomanip.h:31,
from test.cc:4:
/usr/lib/gcc/i486-linux-gnu/4.1.2/../../../../include/c++/4.1.2/backward/backward_warning.h:32:2: warning: #warning This file includes at least one deprecated or antiquated header. Please consider using one of the 32 headers found in section 17.4.1.2 of the C++ standard. Examples include substituting the <X> header for the <X.h> header for C++ includes, or <iostream> instead of the deprecated header <iostream.h>. To disable this warning use -Wno-deprecated.
test.cc: In function ‘bool CreateDatabase()’:
test.cc:31: error: ‘mysql_connect’ was not declared in this scope
root@xxx-laptop:/home/xxxx/Desktop/xxx#

Hi

The problem is the line
using namespace std;

Here you say you are using the std namespace. The mysql functions are not in that namespace, try to change "mysql_connect" into "::mysql_connect". I guess the functions are in the global namespace.

http://www-ccs.ucsd.edu/c/lib_over.html This will clear up the syntax errors. For the vernacular arguments, try http://www.tldp.org/HOWTO/HOWTO-INDEX/howtos.html