MySQL installation for Hadoop---cluster

MySQL installation for Hadoop---cluster

One:　　

　　

　　Two:

　　

　　 Three:

　　

Four:

　　

　　 Five:

　　

　 Six:

　　

　 Seven:

　　

　 Eight: Modify database character: Solve Chinese garbled problem, mysql default is latin1, we want to change to Utf-81>

　　　

　　　 2> Then we do modify:--> first we need to build a folder for MySQL at/etc/--and then copy/usr/sharemysql/my-medium.cof to/ect/mysqlthen modify MY-MEDIUM.COF's name to MY.CNF

　　　

　　 3> Modifying a configuration file

　　　

4> View

Nine: operation of the database under Linux:

1) View the version number of the MySQL database and the current date of the server

　　

2) Displays a summary of the tables in the MySQL database

3) Create a database and select a database to make it the current operational database

　　

4) View the name of the database currently being manipulated

5) Create a table, view the table, and view the table details

　　

6) Insert the data and view the data in the table. MultiRow Insert Add ' values (), () '

　　

7) Update the data in the table using the UPDATE statement

　　

Then simply install and manipulate the database.

　 10: Open Linux Database with port number using local database

　　

OK!!!, we're going to eat, bye.

　　

Huhu_k: Eat very hungry every day ....

　　

　　

　　

　　

MySQL installation for Hadoop---cluster