WZHU's BLOG
HEAD
- 有一种精神,叫"公诚勤朴"
Recent Posts
- 导出Gmail通讯录(Export Gmail Contacts)
- Subversion 强制用户写备注(日志)才能提交.
- Linux 时间服务器同步命令
- PHP修改 LDAP用户密码程序
- Subversion安装与配置
- 我的Subversion使用LDAP认证之Apache配置实例
- HTTP协议(RFC2616)中的方法定义
- 我的HTTP Client 模拟PHP Class
- 我所使用的PHP图形验证码程序.
- DNS Bind9 配置实例
- (联合早报)中国社会信任的解体及其结果(转)
- Linux+Apache+MySQL+PHP 安装配置(三)——freeType,libpng,jpeg,gd,mcrypt,mhash,imap,PHP安装
- Linux+Apache+MySQL+PHP 安装配置(二)—— Apache安装
- Linux+Apache+MySQL+PHP 安装配置(一)—— MySQL安装
- 甲型H1N1流感防病要诀!
Recent Comments
挣点外快
Linux+Apache+MySQL+PHP 安装配置(一)—— MySQL安装
作者: 时间: 2009-06-06 13:15:12
Info
| Name | Version | Home URL(Download HOme) | Install Path | Remark |
| MySQL | 5.1.35 | http://dev.mysql.com/downloads/mysql/5.1.html#source | /usr/local/mysql |
Install
[root@wzhu ~]# groupadd mysql
[root@wzhu ~]# useradd -g mysql -m -d /usr/local/mysql -r mysql
[root@wzhu ~]# tar zxf mysql-5.1.35.tar.gz
[root@wzhu ~]# cd mysql-5.1.35
[root@wzhu mysql-5.1.35]# ./configure \
> --prefix=/usr/local/mysql/ \
> --enable-local-infile \
> --with-charset=utf8 \
> --with-extra-charsets=all \
> --with-system-type=centos \
> --with-machine-type=powerpc \
> --with-pthread \
> --with-unix-socket-path=/tmp/mysql.sock \
> --with-mysqld-user=mysql \
> --with-ssl \
> --with-mysqlmanager \
> --with-big-tables \
> --with-plugins=all
[root@wzhu mysql-5.1.35]# make
[root@wzhu mysql-5.1.35]# make install
[root@wzhu mysql-5.1.35]# cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
[root@wzhu mysql-5.1.35]# cd /usr/local/mysql/
[root@wzhu mysql]# chmod -R 755 .
[root@wzhu mysql]# chown -R mysql.mysql .
[root@wzhu mysql]# bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var
[root@wzhu mysql]# chown -R root.mysql .
[root@wzhu mysql]# chown -R mysql.mysql var/
[root@wzhu ~]# useradd -g mysql -m -d /usr/local/mysql -r mysql
[root@wzhu ~]# tar zxf mysql-5.1.35.tar.gz
[root@wzhu ~]# cd mysql-5.1.35
[root@wzhu mysql-5.1.35]# ./configure \
> --prefix=/usr/local/mysql/ \
> --enable-local-infile \
> --with-charset=utf8 \
> --with-extra-charsets=all \
> --with-system-type=centos \
> --with-machine-type=powerpc \
> --with-pthread \
> --with-unix-socket-path=/tmp/mysql.sock \
> --with-mysqld-user=mysql \
> --with-ssl \
> --with-mysqlmanager \
> --with-big-tables \
> --with-plugins=all
[root@wzhu mysql-5.1.35]# make
[root@wzhu mysql-5.1.35]# make install
[root@wzhu mysql-5.1.35]# cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
[root@wzhu mysql-5.1.35]# cd /usr/local/mysql/
[root@wzhu mysql]# chmod -R 755 .
[root@wzhu mysql]# chown -R mysql.mysql .
[root@wzhu mysql]# bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var
[root@wzhu mysql]# chown -R root.mysql .
[root@wzhu mysql]# chown -R mysql.mysql var/
Start MySQL
[root@wzhu mysql]# bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf --user=mysql > /dev/null &
Set MySQL root password
[root@wzhu mysql]# /usr/local/mysql/bin/mysqladmin -u root password 123456
相关评论
- lawrence 发布于 2009-12-01 20:50:26 IP: 59.64.159.*
- joe,开机启动怎么设置来着?
- wzhu 发布于 2009-12-02 17:59:39 IP: 114.242.25.*
- [root@wzhu ~]# echo "/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf --user=mysql > /dev/null &" >> /etc/rc.local