4 5 ubuntu10.10 源码安装mysql 5.1.51

1. 下载 mysql-5.1.51.tar.gz
   


2. 解压 ,注意都在 root权限下进行
  

root@ywx:/home/ywx/yu/mysql# tar zxfv mysql-5.1.51.tar.gz

 
3. 配置 configure

./configure --prefix=/opt/mysql5151/ \
--without-debug \
--enable-assembler \
--enable-thread-safe-client \
--enable-profiling \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static \
--with-charset=latin1 \
--with-extra-charset=utf8,gbk \
--with-mysqld-user=mysql1 \
--without-ebmedded-server \
--with-server-suffix=bbk \
--with-plugins=innobase,partition

4. 安装 源码

root@ywx:/home/ywx/yu/mysql/mysql-5.1.51# make;make install

5. 在/opt/mysql5151/ 建立 data

root@ywx:/opt/mysql5151# mkdir data
root@ywx:/opt/mysql5151#chown ywx:ywx ./data/ -R

 chown ywx:ywx ./data/ -R  ; ywx:ywx 用户组：用户名


6.复制配置文件

root@ywx:/opt/mysql5151# cp /home/ywx/yu/mysql/mysql-5.1.51/support-files/my-small.cnf ./my.cnf

7.修改my.cnf

thread_stack = 128K

basedir=/opt/mysql5151 添加
datadir=/opt/mysql5151/data  添加

8. 配置文件

root@ywx:/opt/mysql5151# ./bin/mysql_install_db --user=ywx

root@ywx:/opt/mysql5151# ./bin/mysqld_safe --defaults-file=./my.cnf --user=ywx

 select version();

9. 启动mysql

root@ywx:/opt/mysql5151# ./bin/mysql --defaults-file=./my.cnf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.51bbk Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

在安装好的目录 data下，包括日志文件，进程文件，错误文件



10.重新启动电脑，我们来试着 使用 mysql


   1. 启动数据库服务，注意是在后台服务的。root 权限

ywx@ywx:~/yu$ sudo /opt/mysql5151/bin/mysqld_safe --defaults-file=/opt/mysql5151/my.cnf --user=ywx &

  
    2. 启动数据库，可以在 用户模式下

ywx@ywx:~/yu$ /opt/mysql5151/bin/mysql --defaults-file=/opt/mysql5151/my.cnf

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.51bbk Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.03 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.51bbk |
+-----------+
1 row in set (0.00 sec)

mysql> exit
Bye
ywx@ywx:~/yu$