- 首先安装各种依赖环境
yum -y install autoconf automake libtool cmake ncurses-devel openssl-devel lzo-devel zlib-devel gcc gcc-c++ yum -y install make bison-devel libaio yum install bison -y yum install perl-Data-Dumper -y yum install net-tools -y
- 创建一个安装软件的文件夹,并将mysql安装包上传到此路径下,并且解压
mkdir /application cd /application/ mv /root/mysql-5.5.32.tar.gz ./ tar -zxf mysql-5.5.32.tar.gz
- 添加mysql用户,设置禁用mysql用户登录
-
groupadd mysql useradd -s /sbin/nologin -g mysql -M mysql
- 将上述准备环境设置好后开始安装mysql
- 编译
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_CHARSETS=gbk,gb2312,utf8,ascii -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITH_FAST_MUTEXES=1 -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0
- 安装
编译安装这两步操作的时候记得 echo $? 如果结果不是0的话,就出错了,解决错误以后,再重新编译make &make install
- 设置软链接
ln -s /application/mysql-5.5.32/ /application/mysql
- 加入环境变量
echo 'export PATH=/application/mysql/bin:$PATH'>>/etc/profile
- 设置权限
chown -R mysql.mysql /application/mysql/ chmod 755 /application/mysql/scripts/mysql_install_db
- 更改配置文件及其权限
cp support-files/my-medium.cnf /etc/my.cnf cp support-files/mysql.server /etc/init.d/mysqld
-
chmod -R 755 /etc/my.cnf
-
vim /etc/init.d/mysqld //添加basedir=/application/mysql datadir=/application/mysql/data
-
vim /etc/my.cnf //添加basedir=/application/mysql datadir=/application/mysql/data
- 初始化 MySQL 配置表
/application/mysql/scripts/mysql_install_db --user=mysql
- 设置mysql密码
/application/mysql/bin/mysqladmin -u root password '123456'
- 启动mysql
/application/mysql/bin/mysqld_safe &
- 查看mysql进程
ps -ef|grep mysql