debian编译安装mysql_Debian编译安装MySQL-Server5.5.x

以root登陆。

安装依赖包：

apt-get install -y gcc libncurses5-dev

cmake chkconfig

下载MySQL

wget

ftp://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/mysql-5.5.17.tar.gz

创建MySQL用户

groupadd mysql

useradd -g mysql mysql -s /usr/sbin/nologin

创建安装目录

mkdir -p /usr/local/platform/mysql

解压mysql

tar zxvf mysql-5.5.17.tar.gz

cd mysql-5.5.17

使用CMAKE编译

cmake

-DCMAKE_INSTALL_PREFIX=/usr/local/platform/mysql \

-DMYSQL_DATADIR=/home/mysql/3306/data \

-DDEFAULT_CHARSET=utf8 \

-DWITH_READLINE=1 \

-DWITH_SSL=system \

-DWITH_EMBEDDED_SERVER=1 \

-DENABLED_LOCAL_INFILE=1 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_DEBUG=0

安装

make && make install

以下命令照敲:

cp support-files/my-medium.cnf

/usr/local/platform/mysql/my.cnf

chmod +x /usr/local/platform/mysql

chown -R mysql.mysql /usr/local/platform/mysql

cp /usr/local/platform/mysql/support-files/mysql.server

/etc/init.d/mysql

chmod +x /etc/init.d/mysqlchkconfig

--level 2345 mysql on

修改配置文件

vim /usr/local/platform/mysql/my.cnf

在mysqld下加入：

datadir=/data/mysqldata

default-storage-engine=MyISAM

user = mysql

初始化数据库

/usr/local/platform/mysql/scripts/mysql_install_db

--basedir=/usr/local/platform/mysql --datadir=/data/mysqldata

--user=mysql

启动MySQL

service mysql start

初始化root密码

/usr/local/platform/mysql/bin/mysqladmin

-u root password 新密码