Linux环境下安装Mysql-5.5.9(40)_MySQL

下载:
bison-2.5.tar.gz
cmake-2.8.4.tar.gz
m4-1.4.9.tar.gz
make-3.82.tar.gz
mysql-5.5.9.tar.gz
ncurses-devel-5.7-3.20090208.el6.i686.rpm

解压:
tar -zxvf bison-2.5.tar.gz
cd bison-2.5
./configure
make
make install

tar -zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./configure
make
make install

tar -zxvf m4-1.4.9.tar.gz
cd m4-1.4.9
./configure
make
make install

tar -zxvf make-3.82.tar.gz
cd make-3.82
./configure
make
make install

tar -zxvf mysql-5.5.9.tar.gz
进入mysql目录:
cd mysql-5.5.9
执行:
cmake . /
-DCMAKE_INSTALL_PREFIX=/usr/local/xiaorui/mysql/mysql-5.5.9 /
-DMYSQL_DATADIR=/usr/local/mysql/data /
-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysqld.sock /
-DDEFAULT_CHARSET=utf8 /
-DDEFAULT_COLLATION=utf8_general_ci /
-DEXTRA_CHARSETS=all /
-DENABLED_LOCAL_INFILE=1
注意:如果/tmp/mysqld.sock存在,就cp到/usr/local/mysql/data中.

报错(如无报错直接make & make install 即可)：
CMake Error at cmake/readline.cmake:82 (MESSAGE):
Curses library not found. Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on RedHat and derivates it is ncurses-devel.
Call Stack (most recent call first):
cmake/readline.cmake:126 (FIND_CURSES)
cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT)
CMakeLists.txt:256 (MYSQL_CHECK_READLINE)
-- Configuring incomplete, errors occurred

安装:
rpm -ivh ncurses-devel-5.7-3.20090208.el6.i686.rpm
rm -f CMakeCache.txt
cmake . /
-DCMAKE_INSTALL_PREFIX=/usr/local/xiaorui/mysql/mysql-5.5.9 /
-DMYSQL_DATADIR=/usr/local/mysql/data /
-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysqld.sock /
-DDEFAULT_CHARSET=utf8 /
-DDEFAULT_COLLATION=utf8_general_ci /
-DEXTRA_CHARSETS=all /
-DENABLED_LOCAL_INFILE=1

make

make install

cd mysql-5.5.9
cp support-files/my-huge.cnf /etc/my.cnf

增加权限:
chown mysql:mysql /etc/my.cnf
chown -R mysql:mysql /usr/local/mysql/data
chown -R mysql:mysql /usr/local/xiaorui/mysql/mysql-5.5.9
chown -R mysql:mysql /usr/local/

切换用户:
su mysql
进入mysql目录
cd mysql-5.5.9/scripts
初始化mysql:
增加执行权限:
chmod a+x mysql_install_db
执行:
./mysql_install_db --user=mysql --basedir=/usr/local/xiaorui/mysql/mysql-5.5.9 --ldata=/usr/local/mysql/data &

开启:
cd mysql-5.5.9/bin
执行:
./mysqld_safe --user=mysql --datadir=/usr/local/mysql/data/ &

查看是否开启:
ps -ef | grep mysql
如果有信息:
root 26502 26379 1 10:51 pts/2 00:00:00 /bin/sh ./mysqld_safe --user=mysql --datadir=/usr/local/mysql/data/
mysql 26766 26502 5 10:51 pts/2 00:00:00 /usr/local/xiaorui/mysql/mysql-5.5.9/bin/mysqld --basedir=/usr/local/xiaorui/mysql/mysql-5.5.9 --datadir=/usr/local/mysql/data/ --plugin-dir=/usr/local/xiaorui/mysql/mysql-5.5.9/lib/plugin --user=mysql --log-error=/usr/local/mysql/data//hadoop2.err --pid-file=/usr/local/mysql/data//hadoop2.pid --socket=/tmp/mysql.sock --port=3306
查看:
--socket=/tmp/mysql.sock
查看tmp目录下是否有mysql.sock文件.
如果有就正常.
如果没有就杀掉进程重新执行初始化mysql:
kill -9 26502
kill -9 26766
重新初始化mysql:
cd mysql-5.5.9/scripts
./mysql_install_db --user=mysql --basedir=/usr/local/xiaorui/mysql/mysql-5.5.9 --ldata=/usr/local/mysql/data &

配置环境变量:
cd $HOME
vim .bash_profile
添加:
export MYSQL_HOME=/usr/local/xiaorui/mysql/mysql-5.5.9
PATH=$MYSQL_HOME/bin:$PATH
export PATH

use mysql;

进入mysql:
./mysql -uroot -p
初始化root密码:
update user set password=PASSWORD('123456') where User='root';
mysqladmin -u root password 'mysql321'
mysqladmin -u root -h hadoop1 password 'mysql321'
mysqladmin -u root -h localhost password 'mysql321'
mysql -u root --password='mysql321'

create database hivedb;
GRANT ALL PRIVILEGES ON hivedb.* TO 'hiveusr'@'%' IDENTIFIED BY 'hiveusr321' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON hivedb.* TO 'hiveusr'@'localhost' IDENTIFIED BY 'hiveusr321' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON hivedb.* TO 'hiveusr'@'hadoop1' IDENTIFIED BY 'hiveusr321' WITH GRANT OPTION;
FLUSH PRIVILEGES;

注意:
hivedb:hive元数据库
hiveusr:数据库用户

如果mysql.sock在其他位置:
创建链接:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

保护mysql.sock文件:
chmod +t /tmp/mysql.sock