Write a C/C++ program that connects to a MySQL server and
checks intrusion attempts every 5 minutes. If an intrusion
attempt is detected beep the internal speaker to alert the
administrator. A high number of aborted connects to MySQL at
a point in time may be used as a basis of an intrusion.
Answer Posted / raghavendra
/* Simple C program that connects to MySQL Database server*/
#include <mysql.h>
#include <stdio.h>
main() {
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
char *server = "localhost";
char *user = "root";
char *password = "PASSWORD"; /* set me first */
char *database = "mysql";
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);
}
Is This Answer Correct ? | 17 Yes | 11 No |
Post New Answer View All Answers
Explain how many levels deep can include files be nested?
Explain how do you sort filenames in a directory?
Can two or more operators such as and be combined in a single line of program code?
Hai sir, I had planned to write the NIC scientific engineer exam , plz post the sample question......
Explain how are portions of a program disabled in demo versions?
What is this infamous null pointer, anyway?
How can you tell whether two strings are the same?
List some basic data types in c?
What are the functions to open and close the file in c language?
What is the difference between struct and typedef struct in c?
Why do we use int main instead of void main in c?
What is the difference between #include
What is c programing language?
typedef struct{ char *; nodeptr next; } * nodeptr ; What does nodeptr stand for?
Difference between MAC vs. IP Addressing