lamp平台搭建的总结(1)
lamp平台搭建的总结(1)
图-LAMP
lamp平台搭建:linux+apache+mysql+PHP
1.安装mysql-5.1.36
软件获取:
http://dev.mysql.com/downloads/
安装步骤:
tar xvfz mysql-5.1.36.tar.gz
cd mysql-5.1.36
./configure –prefix=/usr/local/mysql \
–with-extra-charsets=all \
–sysconfdir=/usr/local/mysql/etc \
–localstatedir=/var/lib/mysql \
–with-unix-socket-path=/usr/local/mysql/var/mysql.sock \
–with-charset=gbk \
–with-collation=gbk_chinese_ci
(gbk和gbk_chinese_ci的加载可处理中文乱码问题)
make
make install
(注意:虽然在./configure后加上了–localstatedir=/var/lib/mysql但是并未在/var/lib下产生mysql目录,所以我们要在源码包编译安装完成之后先检查一下是否有这个目录,如果没有的话一定要手动创建一个:mkdir /var/lib/mysql)
groupadd mysql
useradd –g mysql -d /home/mysql –s /bin/bash –c “MySQL user” mysql
(为了安全,我们建一个普通用户来初始化数据库,mysql的主目录在/usr/local/var下,而且这个用户是不能登陆服务器的。)
cp /usr/local/mysql/share/mysql/my-large.cnf /etc/my.cnf
cd /usr/local/mysql
./bin/mysql_install_db –user=mysql
(初始化数据库,在/var/lib/mysql下将会产生相应的数据库文件。升级的话不用这步。)
chown -R root:mysql .
chown -R mysql:mysql /var/lib/mysql
/usr/local/mysql/bin/mysqld_safe &
(启动服务器,&表示在后台运行,以后的启动不会再使用这个命令。以后的启动利用/usr/local/mysql/share/mysql/中的启动文件mysql.server启动。)
/usr/local/mysql/bin/mysql –u root –p
(如果没有密码用/usr/local/mysql/bin/mysql)
cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
之后可执行 service mysql start或service mysql restart或service mysql stop来启动或停止MySQL服务。/etc/init.d/mysql start也可。
chkconfig mysql on
chkconfig –add mysql
chkconfig –level 345 mysql on
(设置开机自动启动MySQL服务)
查看3306端口是否打开:
netstat -atln
设置MySQL的root密码(非系统的root):
评论暂时关闭