这个不能添加附件的?
MySQL 5.5.28 源码在CentOS7.2ppc64le上编译知道
下载源码链接:
https://downloads.mysql.com/archives/community/
操作系统配置好yum源
a. 自带光盘iso作为本地yum源。
b. 网上yum源,系统装完后在/etc/yum.repos.d/CentOS-Base.repo 文件中。
两个源都可以使用,这里用到的是本地a光盘本地源。
目录说明:
软件安装目录: /usr/local/mysql-5.5-28/
数据库数据目录: /data/mysql
源码解压位置:/home
编译准备工作
yum安装cmake、automake 、autoconf ,另MySQL 5.5.x需要最少安装的包有:bison,gcc、gcc-c++、ncurses-devel
a. yum -y install cmake-2.8.11-5.el7.ppc64le
b. yum -y install automake-1.13.4-3.el7.noarch
c. yum -y install bison-2.7-4.el7.ppc64le
d. yum -y install gcc-4.8.5-4.el7.ppc64le
e. yum -y install gcc-c++.ppc64le
f.yum -y install ncurses-devel.ppc64le
解压下载的安装包
tar -zxvf mysql-5.5.28.tar.gz
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.28\
-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.28/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/usr/local/mysql-5.5.28\
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306
make&&make install
配置mysql
添加用户,用户组
groupadd mysql
useradd mysql –g mysql –s /sbin/nologin
更改目录权限
cd /usr/local (把mysql的目录改成mysql用户组)
chown -R mysql:mysql mysql-5.5.28
chown -R mysql:mysql /data/mysql
chmod 755 scripts/mysql_install_db
初始化mysqldb
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/
按照屏幕输出,输入
/usr/local/mysql/bin/mysqld_safe &
查看mysqld进程已运行
ps –ef|grep mysqld
验证mysql数据库已经成功安装
./mysqladmin –u root password ‘rootroot’
./mysql –u root –p
Trouble shooting 1
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.5.28/ --datadir=/data/mysql/
WARNING: The host 'Centosle04' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
解:将主机名添加到/etc/hosts
Trouble shooting 2
一直没有看到有mysql.sock文件生成,mysqld进程也没有。
解:没有启动mysql server端,运行命令
/usr/local/mysql/bin/mysqld_safe &
参考链接:
http://www.bkjia.com/rjyy/611899.html