Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 11223 Views
- Drona Solutions, Infosys, Vodafone, Webyog, I also Faced
- E-Mail Answers
Answer Posted / jack
#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 ? | 5 Yes | 11 No |
Post New Answer View All Answers
Why is sprintf unsafe?
Function which gives a pointer to a binary trees const an integer value at each code, return function of all the nodes in binary tree.?
What is the value of a[3] if integer a[] = {5,4,3,2,1}?
Explain how do you generate random numbers in c?
Can a variable be both const and volatile?
Explain how do I determine whether a character is numeric, alphabetic, and so on?
in any language the sound structure of that language depends on its a) character set, input/output function, its control structures b) character set, library functions, input/output functions its control structures c) character set, library functions, control sturctures d) character set, operators, its control structures
Input is "rama loves rajesh and rajesh Loves rama also and rajesh wear gloves and bloves" To print output is count the numbers of times repeted the word love without case sensitive.
How is actual parameter different from the formal parameter?
What is the use of #include in c?
What is the size of structure in c?
"%u" unsigned integer print the a) address of variable b) value of variable c) name of a variable d) none of the above
Where are local variables stored in c?
What is the difference between array and linked list in c?
Between macros and functions,which is better to use and why?
