CentOS Build Mysql/hadoop/hive/hbase

CentOS builds the Eclipse C + + Environment

Only CDT is needed, decompression run, new project, operation

Report Program g++ not found in path:

Eclipse's window--"preference--" c/c++--"Build--" setting-"discovery--"CDT GCC build in Complier Settings [Shar Ed] From: ${command}-e-p-v-dd ' ${inputs} ' to:/usr/bin/${command}-e-p-v-dd ' ${inputs} ' then OK

"Launch failed. Binary not found Linux" appears:

In the menu-->project-->build project

TXT file under Windows is opened as garbled under CentOS

Cause: The default character set under Windows is GB2312, while Linux defaults to Utf-8

So either save in utf-8 format under Windows, or convert the file format, as follows:

Character conversion via Iconv iconv-f gb2312-t UTF8./reading notes. txt >./new.txt

Cat./new.txt

CentOS Install MySQL

:: Http://dev.MySQL. com/downloads/

http://mysql.mirror.kangaroot.net/Downloads/MySQL-5.7/

Create target user and user group permissions

[[email protected]] Groupadd MySQL
[[Email Protected]]useradd-r-G MySQL MySQL

Yum installation, if you need a later version you can download it yourself

Yum-y Install Mysql-server installation version is low

Set character sets and Telnet

Vim/etc/my.cnf

[client]port=3306socket=/var/lib/mysql/mysql.sockdefault-character-set=utf8[mysqld]datadir=/var/lib/ mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# disabling symbolic-links is recommended to prevent assorted security Riskssymbolic-links=0default-character-set = Utf8character-set-server=utf8collation-server=utf8_general_ciinit_ connect= ' Set collation_connection=utf8_general_ci ' init_connect= ' Set NAMES UTF8 ' [mysqld_safe]log-error=/var/log/ Mysqld.logpid-file=/var/run/mysqld/mysqld.piddefault-charater-set=utf8

Set boot up

Chkconfig mysqld on

Chkconfig--list mysqld

/etc/rc.d/init.d/mysqld start

Set a password for root

Mysql-urootselect User,host,password from  mysql.user;set password for [email protected] = password (' 123456 '); exit; Re-login to see if it takes effect.

Open remote Connection

mysql> use mysql;mysql> desc user;mysql> GRANT All privileges on * * to [email protected] '% ' identified by ' root ' ;//The ability to add remote connections for root mysql> update user Set Password = Password (' 123456 ') where user= ' root ';//set root user password mysql> Select Host,user,password from User where user= ' root ';mysql> flush privileges;mysql> exit

If you are not able to connect remotely, turn off the firewall
/etc/rc.d/init.d/iptables stop

To manually install a later version, refer to:

Http://www.cnblogs.com/zhoulf/archive/2013/01/25/zhoulf.html

Http://www.cnblogs.com/xiongpq/p/3384681.html

CentOS Installation Hive

Cd/usr/local

TAR-ZXVF hive-0.12.0.tar.gz

Ln-s hive-0.12.0 Hive to establish a soft connection

To modify a file:

Modify the name of the Conf under four template files cd  /usr/local/hive/conf copy hive-default.xml.template hive-site.xml copy hive-env.sh.template hive-env.sh copy hive-exec-log4j.properties.template hive-exec-log4j.properties copy hive-log4j.properties.template Hive-log4j.properties

There are bugs in the hive-default.xml.template in the official 0.12.0 release, on line 2000:

　　　　<value>auth</auth> Modified to:<value>auth</value>

Hive-env.sh, at the end add:

Export hive_conf_dir= $HIVE _home/confexport hive_aux_jars_path= $HIVE _home/lib

Hive-site.xml: Here are the key-value pairs that need to be modified, the rest of the default

<configuration>

<property> <name>hive.metastore.local</name> <value >true</value> </property> <property> <name> Javax.jdo.option.connectionurl</name> <value>jdbc:mysql://192.168.0.120:3306/hive? createdatabaseifnotexist=true</value> </property> <property> <name> Javax.jdo.option.connectiondrivername</name> <value>com.mysql.jdbc.Driver</value> </ property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hive<     ;/value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>123456</value> </property> <property>  <name>datanucleus.fixeddatasto re</name> <value>false</value> </property> 
 </configuration> 

　　

Feel the style of blog Park is simple and comfortable

CentOS Build Mysql/hadoop/hive/hbase