Install MySQL under Hadoop

Installing MySQL on Ubuntu is very simple and requires just a few commands to complete.

1. sudo apt-get install mysql-server 2.  Apt-get Isntall mysql-client 3. sudo apt-get install Libmysqlclient-dev the installation process will prompt to set a password or something, note the settings do not forget that after the installation is complete, you can use the following command to check whether the installation is successful: sudo netstat-tap | 　　After grep MySQL is checked by the above command, if you see a socket with MySQL in the Listen state, the installation is successful. 　　 　　Log in to the MySQL database can be the following command: Mysql-u root-p-U to select the login user name,-p indicates the login user password, the above command input will prompt for password, then enter the password can log in to MySQL. then through show databases;　　You can view the current database. We choose the MySQL database to do the next step, using the use MySQL command, display the current database form: Show tables write a simple program to access the database, implement Show tables function:

#include <mysql/mysql.h> #include <stdio.h> #include <stdlib.h>int main () {    MySQL *conn;    Mysql_res *res;    Mysql_row ROW;    Char server[] = "localhost";    Char user[] = "root";    Char password[] = "Mima";    Char database[] = "MySQL";        conn = Mysql_init (NULL);        if (!mysql_real_connect (conn, server,user, password, database, 0, NULL, 0))     {        fprintf (stderr, "%s\n", Mysql_ ERROR (conn));        Exit (1);    }        if (mysql_query (conn, "Show Tables"))     {        fprintf (stderr, "%s\n", MYSQL_ERROR (conn));        Exit (1);    }        res = MYSQL_USE_RESULT (conn);        printf ("MySQL Tables in MySQL database:\n");        while (row = mysql_fetch_row (res)) = NULL)    {        printf ("%s \ n", row[0]);    }        Mysql_free_result (res);    Mysql_close (conn);        printf ("finish! \ n ");    return 0;}

Compiling the code requires a link to the MySQL library, which can be compiled in the following ways:

g++-wall Mysql_test.cpp-o mysql_test-lmsqlclient

Then run the compiled code:

The visible results are the same as show tables with the SQL statement.

Install MySQL under Hadoop