Lamp二进制版本的安装

二进制版 

就是指已经编译OK的版本，和rpm版一样功能已经定制好了，如果要使用新功能就需要重新编译

这是第一次安装，二进制版本的步骤

shell>  groupadd mysql

shell> useradd -g mysql mysql

shell> cd /usr/local

shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -

shell> ln -s full-path-to-mysql-VERSION-OS mysql

shell> cd mysql

shell> scripts/mysql_install_db --user=mysql

shell> chown -R root  .

shell> chown -R mysql data

shell> chgrp -R mysql .

shell> bin/mysqld_safe --user=mysql &

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

# tar xvf /share/soft/lamp/mysql_source/mysql-5.1.36-linux-i686-glibc23.tar.gz -C /usr/local/

# cd /usr/local/

# mv mysql-5.1.36-linux-i686-glibc23/ mysql

# cp support-files/mysql.server  /etc/init.d/mysql2 --拷贝服务脚本

# chmod 755 /etc/init.d/mysql2

# vim /etc/init.d/mysql2 

  conf=/usr/local/mysql/etc/my.cnf --修改读取的配置文件路径，不要读/etc/my.cnf，因为我们rpm版也装着，不让他们冲突

# mkdir /usr/local/mysql/etc

# vim /usr/local/mysql/etc/my.cnf --建立新的配置文件路径，写上基础参数

[mysqld]

datadir=/usr/local/mysql/data

port=3307

socket=/var/run/mysqld/mysql2.socket

pid-file=/var/run/mysqld/mysql2.pid

log-error=/var/log/mysqld/mysql2.log

# mkdir /var/run/mysqld/ /var/log/mysqld

# chown mysql.mysql -R /usr/local/mysql/ /var/run/mysqld /var/log/mysqld

--创建配置文件里相应的目录，并修改权限为mysql的owner和group

# /usr/local/mysql/scripts/mysql_install_db --datadir=/usr/local/mysql/data --user=mysql

--初始化

# /etc/init.d/mysql2 start --启动服务

# lsof -i:3307   －－追踪端口有无被占用

COMMAND  PID  USER   FD   TYPE DEVICE SIZE NODE NAME

mysqld  6541 mysql   10u  IPv4  36974       TCP *:opsession-prxy (LISTEN)

# /usr/local/mysql/bin/mysql --直接登录报错，因为默认socket路径它不能找到

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

解决方法：

# vim /usr/local/mysql/etc/my.cnf --加上下面两句

[client]

socket=/var/run/mysqld/mysql2.socket

# /usr/local/mysql/bin/mysql --再次登录就成功了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26465805/viewspace-719984/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26465805/viewspace-719984/