如何在linux下安装mysql

1、安装cmake

tar zxf untar/cmake-2.8.8.tar.gz

pushd cmake-2.8.8

./bootstrap &&gmake &&gmake install

popd

2、创建用户

groupadd mysql

useradd -g mysql mysql

mkdir -p /usr/local/mysql

mkdir -p /var/lib/mysql

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

chown -R mysql.mysql /var/lib/mysql

3、安装mysql

tar zxf untar/mysql-5.6.12.tar.gz

pushd mysql-5.6.12

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS:STRING=all \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/var/lib/mysql \

-DMYSQL_USER=mysql

make

make install

4、启动脚本和配置文件

cp /opt/LNMP/mysql-5.6.12/support-files/my-default.cnf /usr/local/mysql/my.cnf

cp /opt/LNMP/mysql-5.6.12/support-files/mysql.server /etc/init.d/mysqld

5、初始化mysql

cd /usr/local/mysql

./scripts/mysql_install_db –datadir=/var/lib/mysql –user=mysql

6、启动mysql

chmod +x /etc/init.d/mysqld

chkconfig mysqld on

/etc/init.d/mysqld start

7、设置root密码

./bin/mysqladmin -u root password ‘123456’

8、检查端口

netstat -ntlp |grep 3306

9、删除不必要的用户

mysql -uroot -p123456 -e”drop user ”@’localhost'”

mysql -uroot -p123456 -e”drop user ”@’`hostname`'”

mysql -uroot -p123456 -e”drop user ‘root’@’`hostname`'”

mysql -uroot -p123456 -e”drop user root@’::1′”

10、#创建数据库

mysql -uroot -p123456 -e”create database db01”

#创建用户

mysql -uroot -p123456 -e”CREATE USER ‘user01’@’localhost’ IDENTIFIED BY ‘123456’”

mysql -uroot -p123456 -e”GRANT ALL ON db01.* TO ‘user01’@’localhost’”

这个是压缩包文件，而不是你的安装文件，当你用./configure安装的时候，应该有用--prefix指定安装路径，那么就进入你的指定安装路径中，那里面有这个文件例如：./configure--prefix=/usr/local/mysqlcd/usr/local/mysql/scriptsmysql_install_db--user=mysql

1、安装库：

CentOS ：yum install libc-client-devel

Debian：apt-get install libc-client-dev

2、进入php安装目录的ext目录

比如php的安装目录为：/root/lnmp0.4-full/php-5.2.10/

则执行：cd /root/lnmp0.4-full/php-5.2.10/ext/

我们要安装imap模块，执行cd imap/

再执行 /usr/local/php/bin/phpize返回信息：

Configuring for:

PHP Api Version: 20041225

Zend Module Api No: 20060613

Zend Extension Api No: 220060519

执行以下命令：

[root@vpser imap]# ./configure --with-php-config=/usr/local/php/bin/php-config

[root@vpser imap]# make &&make install

返回：

Build complete.

Don't forget to run 'make test'.

Installing shared extensions: /usr/local/php/lib/php/extensions/no-debug-non-zts-20060613/

已经成功，再修改/usr/local/php/etc/php.ini

查找：extension = 再最后一个extension= 后面添加上extension = "imap.so"

保存，执行/root/lnmp restart 重启。

---