源碼編譯MySQL 5.1產生InnoDB儲存引擎

./configure --prefix=/home/mysql51/mysql/   --enable-assembler --enable-local-infile --enable-thread-safe-client --with-big-tables --with-charset=utf8  --with-extra-charsets=gbk,gb2312,utf8,ascii  --with-readline --with-ssl  --with-embedded-server --with-pthread --with-mysqld-user=mysql51  --with-plugins=all > /home/mysql51/mysql_setuplogs_configure.log 2>&1./scripts/mysql_install_db --basedir=/home/mysql51/mysql  --datadir=/home/mysql51/mysql/data --user=mysql51 --defaults-file=/home/mysql51/mysql/my.cnf --forcemysqld_safe --defaults-file=/home/mysql51/mysql/my.cnf &mysqladmin -u root -S /home/mysql51/mysql/mysql.sock password 'oracle'

mysql> select version();+------------+| version()  |+------------+| 5.1.72-log |+------------+mysql> show plugins;+------------+----------+----------------+---------+---------+| Name       | Status   | Type           | Library | License |+------------+----------+----------------+---------+---------+| binlog     | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || partition  | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || ARCHIVE    | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || BLACKHOLE  | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || CSV        | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || FEDERATED  | DISABLED | STORAGE ENGINE | NULL    | GPL     || MEMORY     | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || InnoDB     | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || MyISAM     | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || MRG_MYISAM | ACTIVE   | STORAGE ENGINE | NULL    | GPL     || ndbcluster | DISABLED | STORAGE ENGINE | NULL    | GPL     |+------------+----------+----------------+---------+---------+11 rows in set (0.00 sec)mysql> create table test.t_innodb(id int) engine=innodb;Query OK, 0 rows affected (0.04 sec)mysql> show create table test.t_innodb\G;*************************** 1. row ***************************       Table: t_innodbCreate Table: CREATE TABLE `t_innodb` (  `id` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf81 row in set (0.00 sec)ERROR: No query specified

① sock檔案不能放在公用目錄下，比如/tmp
② 啟動mysql時也應該藉助參數--defaults-file來指定設定檔my.cnf 

[root@localhost ~]# netstat -lntp | grep :3306tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      22171/mysqld        [root@localhost ~]# netstat -lntp | grep :3307tcp        0      0 0.0.0.0:3307                0.0.0.0:*                   LISTEN      31183/mysqld