LAMP+Tomcat+Discuz+WordPress【Mysql的安装】

Mysql安装

Mysql版本： 
mysql  Ver 14.14 Distrib 5.5.13, for Linux (i686)using  EditLine wrapper
安装包名称：mysql-5.5.13.tar.gz

首先安装Cmake与Libmcrypt

Cmake

tar -zxvf cmake-2.8.4.tar.gz

cd cmake-2.8.4

./bootstrap

make

make install

 

 

Libmcrypt

tar -zxvf libmcrypt-2.5.8.tar.gz

cd libmcrypt-2.5.8

./configure --prefix=/usr/local/libmcrypt

make

make install

 

安装Mysql

[root@mail~]# groupadd mysql

[root@mail~]# useradd -g mysql -s/sbin/nologin mysql

[root@mail~]# mkdir -p/storage/db/mysql_data

[root@mail~]# mkdir -p /software/mysql

[root@mail~]# mkdir -p /etc/mysql

[root@mailopt]# tar zxvfmysql-5.5.13.tar.gz

[root@mailopt]# cd mysql-5.5.13

[root@mailmysql-5.5.13]# cmake .-DCMAKE_INSTALL_PREFIX=/software/mysql/ -DMYSQL_DATADIR=/storage/db/mysql_data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all  -DWITH_SSL=system -DWITH_ZLIB=system-DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1-DWITH_MYISAM_STORAGE_ENGINE=1 -DSYSCONFDIR=/etc/mysql -DMYSQL_TCP_PORT=7454 -DWITH_DEBUG=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1   -DWITH_ARCHIVE_STORAGE_ENGINE=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1  -DWITH_PARTITION_STORAGE_ENGINE=1

[root@mailmysql-5.5.13]# make &&make install

[root@mailmysql-5.5.13]# cp./support-files/my-innodb-heavy-4G.cnf /etc/mysql/my.cnf

[root@mailmysql-5.5.13]# chown -R mysql/storage/db/mysql_data/

[root@mailmysql-5.5.13]# chgrp -R mysql/storage/db/mysql_data/

[root@mailmysql-5.5.13]# /software/mysql/scripts/mysql_install_db--basedir=/software/mysql/ --user=mysql --datadir=/storage/db/mysql_data/

[root@mailmysql-5.5.13]# cp./support-files/mysql.server /etc/init.d/mysqld【注意路径】

[root@mailmysql-5.5.13]# chmod 755/etc/init.d/mysqld

[root@mailmysql-5.5.13]# vim/etc/init.d/mysqld

basedir=/software/mysql

datadir=/storage/db/mysql_data

[root@mailmysql_data]# /etc/init.d/mysqld  start

StartingMySQL[  OK  ]

[root@mailbin]# vim /etc/profile

exportPATH=$PATH:/software/mysql/bin

[root@mailbin]# source /etc/profile

[root@mailbin]# mysql

Welcome to theMySQL monitor.  Commands end with ; or\g.

Your MySQLconnection id is 2

Server version:5.5.13-log Source distribution

 

Copyright (c)2000, 2010, Oracle and/or its affiliates. All rights reserved.

 

Oracle is aregistered trademark of Oracle Corporation and/or its

affiliates. Othernames may be trademarks of their respective

owners.

 

Type 'help;' or'\h' for help. Type '\c' to clear the current input statement.

 

mysql>

[root@mail~]# chkconfig mysqld on

[root@mail~]# chkconfig --level 24 mysqldoff

[root@mail~]# chkconfig --list mysqld

mysqld          0:off   1:off  2:off   3:on    4:off  5:on    6:off

[root@maillib]# vim /etc/ld.so.conf

/software/mysql/lib

[root@mail~]# ldconfig -v |grep mysql

/software/mysql/lib:

        libmysqlclient.so.18 ->libmysqlclient_r.so.18.0.0

 

 参考：

 http://heylinux.com/archives/993.html

http://blog.sina.com.cn/s/blog_48f9c0840100oi8k.html

【文档下载】http://ishare.iask.sina.com.cn/f/17120832.html