好久没有写贴啦,今天贴个MYSQL简单的安装,供初学的朋友参考.
如有问题请看:
http://dev.mysql.com/doc/refman/5.1/zh/index.html
RPM包安装:
RPM包安装启动失败请看:
[root@www ~]# rpm -qa|grep perl-db -i
复制内容到剪贴板
代码:
perl-DBI-1.40-8 //RPM安装请先安装perl-DBI-*这个包，否则出错
[root@www ~]# rpm -qa|grep mysql -i
复制内容到剪贴板
代码:
MySQL-devel-standard-5.0.27-0.rhel4
MySQL-shared-compat-5.0.27-0.rhel4
MySQL-server-standard-5.0.27-0.rhel4
MySQL-client-standard-5.0.27-0.rhel4/
usr/share/doc/mysql/mysql.server 将其复制/etc/rc.d/init.d/mysql启动即可.
复制内容到剪贴板
代码:
mysqladmin -uroot password '54netseek'源码编译安装:
复制内容到剪贴板
代码:
groupadd mysql
useradd -g mysql -c "MySQL Server" mysql
cd /usr/local/src/mysql-4.0.26
chown -R root.root *
make clean
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--disable-maintainer-mode \
--with-mysqld-user=mysql \
--with-unix-socket-path=/tmp/mysql.sock \
--without-comment \
--without-debug \
--without-bench
make && make install 配置MySQL:
复制内容到剪贴板
代码:
./scripts/mysql_install_db
chown -R root:mysql /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql/data
cp support-files/my-medium.cnf /etc/my.cnf
chown root:sys /etc/my.cnf
chmod 644 /etc/my.cnf 用动态库代替静太库，保持连接:
复制内容到剪贴板
代码:
echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
ldconfig 创建MySQL启动脚本:
cp ./support-files/mysql.server /etc/rc.d/init.d/mysql
chmod +x /etc/rc.d/init.d/mysql
/sbin/chkconfig --level 3 mysql on
执行命令建立软接:
复制内容到剪贴板
代码:
cd /usr/local/mysql/bin
for file in *; do ln -s /usr/local/mysql/bin/$file /usr/bin/$file; done
