Linux C语言程序连接mysql数据库
#include#include
main() {
MYSQL *conn;
MYSQL_RES*res;
MYSQL_ROWrow;
char *server = "localhost";
char *user = "root";
char *password = "nopasswd"; /* set me first */
char *database = "mysql";
char *query = "select Host,User,Password from user";
int t, r;
conn = mysql_init(NULL);
if(!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0))
{
printf("Error connecting to database: %s\n", mysql_error(conn));
}
else
{
printf("Connected....\n");
}
t = mysql_query(conn, query);
if(t)
{
printf("Error making query: %s\n", mysql_error(conn));
}
else
{
printf("Query made...\n");
res = mysql_use_result(conn);
if(res)
{
for(r=0; r
页:
[1]