mysql51在linux下的编译安装.docxVIP

Mysql5.1在linux下的编译安装安装前的准备检查系统环境检查系统环境，是否安装了gcc、gcc-c++ 等编译所需的环境，如果没有安装，请安装gcc 。检查是否安装gcc可以使用如下命令：rpm –qa | grepgcc如果没有安装gcc，可以使用下列命令来安装gcc工具：yum –y install gcc*下载mysql源代码安装包下载mysql-5.*.tar.gz mysql的源代码包可以到mysql的官网上去下载，本文以mysql-5.1.34.tar.gz为例。编译安装mysql创建mysql用户和组创建用户和组使用命令：groupaddmysqluseradd -g mysqlmysql解压源代码包解压源代码包使用命令：tar -zxvf mysql-5.1.34.tar.gz 配置myql配置mysql(首先在/usr/local/下创建mysql目录并在mysql下创建data目录)；此处选择的字符集是gbk也可以选择utf-8、gb2312等;以下均在解压后的mysql-5.1.34目录下执行:#mkdir -p /usr/local/mysql/#mkdir -p /usr/local/mysql/data/ //建立数据库存放目录#mkdir -p /usr/local/mysql/etc/ //建立数据库配置文件存放目录#./configure --prefix=/usr/local/mysql/ --localstatedir=/usr/local/mysql/data/ --sysconfdir=/usr/local/mysql/etc/ --with-charset=utf8编译安装mysql编译：make安装：make install设置文件权限#chown -R root:mysql /usr/local/mysql#chown -R mysql:mysql /usr/local/mysql/data#chown -R mysql:mysql /usr/local/mysql/lib安装数据库文件# cd /usr/local/mysql/bin/ # ./mysql_install_db --user=mysql建立mysql的启动文件# cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld# cp /usr/local/mysql/share/mysql/f /etc/f启动mysql# /usr/local/mysql/share/mysql/mysql.server start如果初次启动出现Starting MySQL.Manager of pid-file quit without updating fi[FAILED]的报错，需要注释/etc/f里的skip-federated注释掉即#skip-federated就OK了1.注释掉 skip-federated，按此方法操作，无果2.关闭selinux如果有错误：/usr/local/mysql/bin/mysqld: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory090320 00:59:22 mysqld_safemysqld from pid file /var/log/mysql/mysql.pid ended090320 01:17:29 mysqld_safe Starting mysqld daemon with databases from /mysql_data/可以看出缺少库文件 libstdc++.so.5。到官方下载：wget /centos/5.2/os/x86_64/CentOS/compat-libstdc++-33-3.2.3-61.x86_64.rpm安装:rpm -ivhcompat-libstdc++-33-3.2.3-61.x86_64.rpm再重新启动MYSQL服务，启动OK.设置mysql的root密码# /usr/local/mysql/bin/mysqladmin -u root password ******登录mysql# /usr/local/mysql/bin/mysql -u root –p然后输入密码//以下是启动mysql的界面：设置mysql开机自启动修改/etc/rc.local文件在 touch /var/lock......（最后一行）的上方添加以下配置/usr/local/my