PHP.ini 設定 MySQL

一、先安裝autoconf

sudo apt-get install autoconf

二、安裝PHP裡mysql套件

cd php-5.5.15/ext/mysql

sudo phpize

sudo ./configure --enable-mysql

sudo make

sudo make test

sudo make install

三、安裝PHP裡mysqli套件

cd ../mysqli

sudo phpize

sudo ./configure --enable-mysqli

sudo make

sudo make test

sudo make install

四、安裝PHP裡pdo_mysql套件

cd ../pdo_mysql

sudo phpize

sudo ./configure --enable-pdo_mysql

sudo make

sudo make test

sudo make install

四、php.ini設定
修改底下把;拿掉

;extension=php_exif.dll      ; Must be after mbstring as it depends on it
extension=mysql.so
extension=mysqli.so
;extension=php_oci8.dll      ; Use with Oracle 10gR2 Instant Client
;extension=php_oci8_11g.dll  ; Use with Oracle 11gR2 Instant Client
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=pdo_mysql.so

重啟Apache2 server

sudo service apache2 restart

How to install MySQL5.6 binary on ubuntu14.10(64Bit)

軟體準備

• mysql-5.6.19.tar.gz

一、MySQL下載及安裝

sudo wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz

sudo gzip -d mysql-5.6.19.tar.gz

sudo tar xvf mysql-5.6.19.tar

sudo groupadd mysql

sudo useradd -g mysql mysql

cd mysql-5.6.19

sudo cmake -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/var/tmp/mysql.sock -DSYSCONFDIR=/etc .

sudo make

sudo make install

二、權限修改或設定

cd /usr/local/mysql

sudo chown -R mysql .

sudo chgrp -R mysql .

sudo scripts/mysql_install_db --user=mysql

三、設定MySQL啟動時間

sudo su mysql

./bin/mysqld_safe start

cd /usr/local/mysql

sudo chown -R root .

sudo chown -R mysql data

sudo cp support-files/mysql.server /etc/init.d/mysql.server

sudo /etc/init.d/mysql.server start

sudo update-rc.d mysql.server defaults

sudo ln -s /usr/local/mysql/bin/* /usr/local/bin/

sudo mysql_secure_installation

參考鏈結：https://www.virgohacks.net/install-apache-2-4-mysql-5-6-php-5-5-source-ubuntu-14-04/