nanopi neo mysql_FriendlyARM NanoPi-NEO中安装LAMP

Linux 的安装

是用原厂提供的image直接刷到16G TF卡中， 4GB卡都足够。Linux 只有600MB多点，版本信息如下：

root@FriendlyARM:/# uname -a

Linux FriendlyARM 3.4.39-h3 #14 SMP PREEMPT Mon Jul 4 10:10:33 CST 2016 armv7l armv7l armv7l GNU/Linux

root@FriendlyARM:/#

root@FriendlyARM:/# uname -a

Linux FriendlyARM 3.4.39-h3 #14 SMP PREEMPT Mon Jul 4 10:10:33 CST 2016 armv7l armv7l armv7l GNU/Linux

root@FriendlyARM:/#

root@FriendlyARM:/# cat /proc/version

Linux version 3.4.39-h3 (root@wwd-ubuntu) (gcc version 4.6.3 20120201 (prerelease) (crosstool-NG linaro-1.13.1-2012.02-20120222 - Linaro GCC 2012.02) ) #14 SMP PREEMPT Mon Jul 4 10:10:33 CST 2016

root@FriendlyARM:/#

root@FriendlyARM:/# cat /etc/issue

Ubuntu 15.10 \n \l

Apache2 2.4.12+MySQL 5.6.31 + Php5.6.11  的安装

安装顺序我是MySQL, Apache, PHP, 因为MySQL最大，都是在线安装的。

占用空间：

MySQL 5.6.31 ： 266MB ,

php5.6.11 :  20MB ,

apache2 2.4.12:　11MB

先进行了这2项，可能不是必须的：

root@FriendlyARM:/# apt-get update

Hit http://ports.ubuntu.com wily InRelease

Hit http://ports.ubuntu.com wily-updates InRelease

Hit http://ports.ubuntu.com wily-security InRelease

Hit http://ports.ubuntu.com wily/main Sources

Hit http://ports.ubuntu.com wily/restricted Sources

Hit http://ports.ubuntu.com wily/main armhf Packages

Hit http://ports.ubuntu.com wily/restricted armhf Packages

Hit http://ports.ubuntu.com wily/main Translation-en

Hit http://ports.ubuntu.com wily/restricted Translation-en

Hit http://ports.ubuntu.com wily-updates/main Sources

Hit http://ports.ubuntu.com wily-updates/restricted Sources

Hit http://ports.ubuntu.com wily-updates/main armhf Packages

Hit http://ports.ubuntu.com wily-updates/restricted armhf Packages

Hit http://ports.ubuntu.com wily-updates/main Translation-en

Hit http://ports.ubuntu.com wily-updates/restricted Translation-en

Hit http://ports.ubuntu.com wily-security/main Sources

Hit http://ports.ubuntu.com wily-security/restricted Sources

Hit http://ports.ubuntu.com wily-security/main armhf Packages

Hit http://ports.ubuntu.com wily-security/restricted armhf Packages

Hit http://ports.ubuntu.com wily-security/main Translation-en

Hit http://ports.ubuntu.com wily-security/restricted Translation-en

Reading package lists... Done

root@FriendlyARM:/#

root@FriendlyARM:/# apt-get install apt-utils

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following packages will be upgraded:

apt-utils

1 upgraded, 0 newly installed, 0 to remove and 44 not upgraded.

Need to get 169 kB of archives.

After this operation, 0 B of additional disk space will be used.

Get:1 http://ports.ubuntu.com/ubuntu-ports/ wily-updates/main apt-utils armhf 1.0.10.2ubuntu3 [169 kB]

Fetched 169 kB in 2s (68.2 kB/s)

(Reading database ... 24210 files and directories currently installed.)

Preparing to unpack .../apt-utils_1.0.10.2ubuntu3_armhf.deb ...

Unpacking apt-utils (1.0.10.2ubuntu3) over (1.0.10.2ubuntu2) ...

Setting up apt-utils (1.0.10.2ubuntu3) ...

root@FriendlyARM:/#

安装"AMP"

root@FriendlyARM:~# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/root 3.6G 603M 3.0G 17% /

devtmpfs 168M 0 168M 0% /dev

tmpfs 248M 0 248M 0% /dev/shm

tmpfs 248M 8.4M 240M 4% /run

tmpfs 5.0M 4.0K 5.0M 1% /run/lock

tmpfs 248M 0 248M 0% /sys/fs/cgroup

root@FriendlyARM:~# apt-get install mysql-server

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18

libterm-readkey-perl mysql-client-5.6 mysql-client-core-5.6 mysql-common

mysql-server-5.6 mysql-server-core-5.6

Suggested packages:

libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl

libipc-sharedcache-perl mailx tinyca

The following NEW packages will be installed:

libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18

libterm-readkey-perl mysql-client-5.6 mysql-client-core-5.6 mysql-common

mysql-server mysql-server-5.6 mysql-server-core-5.6

0 upgraded, 12 newly installed, 0 to remove and 45 not upgraded.

Need to get 18.9 MB of archives.

After this operation, 132 MB of additional disk space will be used.

Do you want to continue? [Y/n]

Filesystem Size Used Avail Use% Mounted on

/dev/root 3.6G 859M 2.7G 24% /

devtmpfs 168M 0 168M 0% /dev

tmpfs 248M 0 248M 0% /dev/shm

tmpfs 248M 8.4M 240M 4% /run

tmpfs 5.0M 4.0K 5.0M 1% /run/lock

tmpfs 248M 0 248M 0% /sys/fs/cgroup

root@FriendlyARM:~#

root@FriendlyARM:~#

root@FriendlyARM:~# apt-get install apache2

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

apache2-bin apache2-data apache2-utils libapr1 libaprutil1

libaprutil1-dbd-sqlite3 libaprutil1-ldap libasn1-8-heimdal

libgssapi3-heimdal libhcrypto4-heimdal libheimbase1-heimdal

libheimntlm0-heimdal libhx509-5-heimdal libkrb5-26-heimdal libldap-2.4-2

liblua5.1-0 libroken18-heimdal libsasl2-2 libsasl2-modules

libsasl2-modules-db libwind0-heimdal ssl-cert

Suggested packages:

www-browser apache2-doc apache2-suexec-pristine apache2-suexec-custom ufw

libsasl2-modules-otp libsasl2-modules-ldap libsasl2-modules-sql

libsasl2-modules-gssapi-mit libsasl2-modules-gssapi-heimdal

openssl-blacklist

The following NEW packages will be installed:

apache2 apache2-bin apache2-data apache2-utils libapr1 libaprutil1

libaprutil1-dbd-sqlite3 libaprutil1-ldap libasn1-8-heimdal

libgssapi3-heimdal libhcrypto4-heimdal libheimbase1-heimdal

libheimntlm0-heimdal libhx509-5-heimdal libkrb5-26-heimdal libldap-2.4-2

liblua5.1-0 libroken18-heimdal libsasl2-2 libsasl2-modules

libsasl2-modules-db libwind0-heimdal ssl-cert

0 upgraded, 23 newly installed, 0 to remove and 45 not upgraded.

Need to get 2288 kB of archives.

After this operation, 7704 kB of additional disk space will be used.

Do you want to continue? [Y/n]

root@FriendlyARM:~# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/root 3.6G 870M 2.7G 25% /

devtmpfs 168M 0 168M 0% /dev

tmpfs 248M 0 248M 0% /dev/shm

tmpfs 248M 8.4M 240M 4% /run

tmpfs 5.0M 4.0K 5.0M 1% /run/lock

tmpfs 248M 0 248M 0% /sys/fs/cgroup

root@FriendlyARM:~#

root@FriendlyARM:~#

root@FriendlyARM:~# apt-get install php5

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

libapache2-mod-php5 libjson-c2 lsof php5-cli php5-common php5-json

php5-readline ucf

Suggested packages:

php-pear php5-user-cache

The following NEW packages will be installed:

libapache2-mod-php5 libjson-c2 lsof php5 php5-cli php5-common php5-json

php5-readline ucf

0 upgraded, 9 newly installed, 0 to remove and 45 not upgraded.

Need to get 4795 kB of archives.

After this operation, 16.3 MB of additional disk space will be used.

Do you want to continue? [Y/n]

root@FriendlyARM:~# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/root 3.6G 890M 2.7G 25% /

devtmpfs 168M 0 168M 0% /dev

tmpfs 248M 0 248M 0% /dev/shm

tmpfs 248M 8.4M 240M 4% /run

tmpfs 5.0M 4.0K 5.0M 1% /run/lock

tmpfs 248M 0 248M 0% /sys/fs/cgroup

root@FriendlyARM:/# apache2 -v

Server version: Apache/2.4.12 (Ubuntu)

Server built: Jul 15 2016 15:32:10

root@FriendlyARM:/#

root@FriendlyARM:/# mysql --version

mysql Ver 14.14 Distrib 5.6.31, for debian-linux-gnueabihf (armv7l) using EditLine wrapper

root@FriendlyARM:/#

root@FriendlyARM:/# php5 -v

PHP 5.6.11-1ubuntu3.4 (cli)

Copyright (c) 1997-2015 The PHP Group

Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies

with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies

root@FriendlyARM:/#

最重要的一点是要单独安装：php5-mysql

apt-get install php5-mysql

如果不安装这个，就会出现PHP5不能访问MySQL的问题

root@FriendlyARM:/var/www/html#

root@FriendlyARM:/var/www/html# apt-get install php5-mysql

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following NEW packages will be installed:

php5-mysql

0 upgraded, 1 newly installed, 0 to remove and 45 not upgraded.

Need to get 53.3 kB of archives.

After this operation, 171 kB of additional disk space will be used.

Get:1 http://ports.ubuntu.com/ubuntu-ports/ wily-updates/main php5-mysql armhf 5.6.11+dfsg-1ubuntu3.4 [53.3 kB]

Fetched 53.3 kB in 3s (14.0 kB/s)

Selecting previously unselected package php5-mysql.

(Reading database ... 22184 files and directories currently installed.)

Preparing to unpack .../php5-mysql_5.6.11+dfsg-1ubuntu3.4_armhf.deb ...

Unpacking php5-mysql (5.6.11+dfsg-1ubuntu3.4) ...

Processing triggers for libapache2-mod-php5 (5.6.11+dfsg-1ubuntu3.4) ...

Setting up php5-mysql (5.6.11+dfsg-1ubuntu3.4) ...

Creating config file /etc/php5/mods-available/mysql.ini with new version

php5_invoke: Enable module mysql for apache2 SAPI

php5_invoke: Enable module mysql for cli SAPI

Creating config file /etc/php5/mods-available/mysqli.ini with new version

php5_invoke: Enable module mysqli for apache2 SAPI

php5_invoke: Enable module mysqli for cli SAPI

Creating config file /etc/php5/mods-available/pdo_mysql.ini with new version

php5_invoke: Enable module pdo_mysql for apache2 SAPI

php5_invoke: Enable module pdo_mysql for cli SAPI

Processing triggers for libapache2-mod-php5 (5.6.11+dfsg-1ubuntu3.4) ...

root@FriendlyARM:/var/www/html#

root@FriendlyARM:/var/www/html#

root@FriendlyARM:/var/www/html#

root@FriendlyARM:/var/www/html# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/root 3.6G 891M 2.7G 25% /

devtmpfs 168M 0 168M 0% /dev

tmpfs 248M 0 248M 0% /dev/shm

tmpfs 248M 8.4M 240M 4% /run

tmpfs 5.0M 4.0K 5.0M 1% /run/lock

tmpfs 248M 0 248M 0% /sys/fs/cgroup

root@FriendlyARM:/var/www/html#

如何判断 PHP5是否支持MySQL扩展(PHP5是否可以访问MySQL)

成功安装后，phpinfo()输出的信息中将会看到以下的"php信息1" 及 "php信息2"，否则只能看到信息1。当然还有很多其它信息。

1.php

phpinfo();

?>

php信息1：

Multibyte String Functions

Tsukada Takuya, Rui Hirokawa

MySQL driver for PDO

George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter

MySQL

Zeev Suraski, Zak Greant, Georg Richter, Andrey Hristov

MySQLi

Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel

MySQLnd

Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter

php信息2：

mysql

MySQL Support

enabled

Active Persistent Links

0

Active Links

0

Client API version

5.6.31

MYSQL_MODULE_TYPE

external

MYSQL_SOCKET

/var/run/mysqld/mysqld.sock

MYSQL_INCLUDE

-I/usr/include/mysql

MYSQL_LIBS

-L/usr/lib/arm-linux-gnueabihf -lmysqlclient_r

Directive

Local Value

Master Value

mysql.allow_local_infile

On

On

mysql.allow_persistent

On

On

mysql.connect_timeout

60

60

mysql.default_host

no value

no value

mysql.default_password

no value

no value

mysql.default_port

no value

no value

mysql.default_socket

/var/run/mysqld/mysqld.sock

/var/run/mysqld/mysqld.sock

mysql.default_user

no value

no value

mysql.max_links

Unlimited

Unlimited

mysql.max_persistent

Unlimited

Unlimited

mysql.trace_mode

Off

Off

mysqli

MysqlI Support

enabled

Client API library version

5.6.31

Active Persistent Links

0

Inactive Persistent Links

0

Active Links

0

Client API header version

5.6.30

MYSQLI_SOCKET

/var/run/mysqld/mysqld.sock

Directive

Local Value

Master Value

mysqli.allow_local_infile

On

On

mysqli.allow_persistent

On

On

mysqli.default_host

no value

no value

mysqli.default_port

3306

3306

mysqli.default_pw

no value

no value

mysqli.default_socket

/var/run/mysqld/mysqld.sock

/var/run/mysqld/mysqld.sock

mysqli.default_user

no value

no value

mysqli.max_links

Unlimited

Unlimited

mysqli.max_persistent

Unlimited

Unlimited

mysqli.reconnect

Off

Off

mysqli.rollback_on_cached_plink

Off

Off

PDO

PDO support

enabled

PDO drivers

mysql

pdo_mysql

PDO Driver for MySQL

enabled

Client API version

5.6.31

Directive

Local Value

Master Value

pdo_mysql.default_socket

/var/run/mysqld/mysqld.sock

/var/run/mysqld/mysqld.sock

一个测试网页

2.php。 功能：

登录MySQL

创建数据库x

创建表p

每访问一次就插入一条记录

我的第一张 PHP 页面

this is xsz test

echo "
" . date("y-m-d H:i:s") . "
";

echo "Hello World!" . "
";

$servername = "localhost";

$username = "root";

$password = "root";

$con = mysqli_connect($servername, $username, $password);

if (!$con) {

die("mysql connect FAILURE. " . $con->connect_error);

}

echo " MYSQL connect OK" . "
";

echo "" . "sqlserverinfo:" ;

print(mysqli_get_server_info($con));

echo "";

$sql = "CREATE DATABASE x";

if ($con->query($sql) === TRUE) {

echo " Create database OK. ";

} else {

echo "Error creating database: " . $con->error;

}

echo "";

print(mysqli_select_db($con,"x"));

echo "";

$sql = "CREATE TABLE p (

id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,

name varchar(30) not null,

yo int not null,

reg_date TIMESTAMP

)";

if ($con->query($sql) == TRUE){

echo "create table ok
";

} else {

echo " create table error" . $con->error;

}

echo "";

print(mysqli_select_db($con,"x"));

$r = mysqli_query($con,"SELECT * FROM p");

echo "";

echo "

id	name	age	reg date

while($row = mysqli_fetch_array($r))

{

echo "

";

echo "

" . $row['id'] . "";

echo "

" . $row['name'] . "";

echo "

" . $row['yo'] . "";

echo "

" . $row['reg_date'] . "";

echo "

";

}

echo "

";

echo "
";

$sql = "INSERT INTO p (name, yo) VALUES ( 'xx" . date("ymd-H:i:s") . "'" .

"," . date("His") . ")";

print($sql);

echo "
";

$con->query($sql);

mysqli_close($con);

echo "
finished. " . date("y-m-d H:i:s") . "
";

?>

2.php 输出结果如下：

我的第一张 PHP 页面

this is xsz test

16-08-21 08:04:27

Hello World!

MYSQL connect OK

sqlserverinfo:5.6.31-0ubuntu0.15.10.1

Error creating database: Can't create database 'x'; database exists

1

create table errorTable 'p' already exists

1

id name age reg date

1xx160821-04:28:31428312016-08-21 04:28:31

2xx160821-04:28:39428392016-08-21 04:28:39

3xx160821-04:28:43428432016-08-21 04:28:43

4xx160821-04:28:45428452016-08-21 04:28:45

5xx160821-04:28:56428562016-08-21 04:28:56

6xx160821-04:28:57428572016-08-21 04:28:57

7xx160821-04:28:59428592016-08-21 04:28:59

8xx160821-04:29:18429182016-08-21 04:29:18

9xx160821-04:29:19429192016-08-21 04:29:19

10xx160821-04:29:22429222016-08-21 04:29:22

11xx160821-04:33:28433282016-08-21 04:33:28

12xx160821-07:03:17703172016-08-21 07:03:17

13xx160821-07:03:21703212016-08-21 07:03:21

14xx160821-08:02:52802522016-08-21 08:02:52

INSERT INTO p (name, yo) VALUES ( 'xx160821-08:04:27',080427)

finished. 16-08-21 08:04:28

注：

以上整个过程除只有MySQL安装过程中要求输入密码外，不需要再对LAMP作任何配置或更改配置文件什么的。

安装完成后只需将1.php, 2.php拷贝到 /var/www/html中， 然后就可以在WEB浏览器中查看效果了。

root@FriendlyARM:/var/www/html# pwd

/var/www/html

root@FriendlyARM:/var/www/html# ll

total 28

drwxr-xr-x 2 root root 4096 Aug 21 08:04 ./

drwxr-xr-x 3 root root 4096 Aug 21 04:07 ../

-rw-r--r-- 1 root root 21 Aug 21 04:20 1.php

-rw-r--r-- 1 root root 1752 Aug 21 08:04 2.php

-rw-r--r-- 1 root root 11321 Aug 21 04:08 index.html