linux下采用cmake或gmake方式编译安装mysql-11027252
仅供学习，共同进步！1.准备工作
hostname mysql 修改主机名
vi /etc/sysconfig/network 永久修改主机名
yum install gcc gcc-c++ 安装gcc
yum install lrzsz -y 安装rz
uname -r
uname -m
2.准备安装包
mkdir /hose/oldboy/tools
cd /hose/oldboy/tools
rz -y cmake-2.8.8.tar.gz
ls -l
tar xfcmake-2.8.8.tar.gz 解压cmake包
cdcmake-2.8.8 进入cmake
./configure 检查并配置
gmake
gmake install 编译安装
echo $? 结果为‘0’ 输出本身值
cd .. 回到上级目录
yum install ncurses-devel -y安装依赖包
groupadd mysql 创建用户
useradd mysql -s /sbin/nologin -M -g mysql 创建组(-s:禁止该用户登录，加强安全。-M不创建用户家目录。-g指定属于mysql的组)
cd /hose/oldboy/tools
rz -y mysql-5.5.32.tar.gz
tar xf mysql-5.5.32.tar.gz 解压
cdmysql-5.5.32 进入mysql
3.编译过程
别手敲，易出错！
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSET=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=on \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPL_ESTORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_ESTORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_ENBEDDED_SERVER=1 \
-DWITH_DEBUG=0
make && make isntall 编译
which cmake 查看安装位置 (/usr/local/bin/cmake)
4.软连接
ln -s /application/mysql-5.5.32/ /application/mysql做个软链接
cp mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf 选择配置文件
cp：是否覆盖"/etc/my.cnf"？y
5.配置环境变量
echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
tail -1 /etc/profile
source /etc/profile
echo $PATH
6.初始化数据文件
ll /application/mysql/data/
chown -R mysql.mysql /application/mysql/data/ 授权用户访问mysql的安装目录
chmod -R 1777 /tmp 调整权限，否则初始化容易出错。（怎么看初始化正确？出现2个OK）
cd /application/mysql/scripts/
./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql
7. 配置主机名
WARNING: The host 'web' could not be looked up with resolveip 提示信息说：web主机名解析不了了。
hostname 查看主机名
vi /etc/hosts (127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 web ) 添加主机名
pingweb ping主机名，返回127.0.0.1
8.启动mysql
cd /home/oldboy/tools/mysql-5.5.32 进入mysql
cp support-files/mysql.server /etc/init.d/mysqld 复到/etc下，其名为mysqld
chmod +x /etc/init.d/mysqld 添加执行权限
/etc/init.d/mysqld start 启动（Starting MySQL...[确定]）
netstat -lntup|grep mysql 查看启动状态
9.mysql建立安全范围
mysql 输入mysql，进入到mysql数据库,出现mysql> 表示进入
select user,host from mysql.user; 查询
delete from mysql.user where host='::1';
delete from mysql.user where host='web';
delete from mysql.user where user='';
drop database test;
mysql>quit 退出mysql
10.修改mysql密码，建立安全渠道
/application/mysql//bin/mysqladmin -u root password 'oldboy123' 为mysql增加密码
mysql -uroot -poldboy123 重新进入mysql
mysql>quit 退出mysql
页:
[1]