在海之舟大数据平台上搭建mysql+php开发平台
海之舟服务器操作系统基于国产arm64,3399cpu，分a版，b版，a版内置了大量软件，开发接口范例。
操作系统是个.img的文件，在windows7下刷入tf卡，开机即可启动。启动后ssh登陆，操作界面如下。
配置文件设置开机启动
root@bigdataA:/home/zs# nano /etc/rc.local
…
su - zs -c'/md1/apache-tomcat-8.5.35/bin/startup.sh'
#sleep 5
#su - zs -c'pgxc_ctl -c /home/zs/pgxc_ctl/pgxc_ctl.conf start all'
#/etc/init.d/apache2 start
#/etc/init.d/mysql start
#/etc/init.d/bind9 start
#/etc/init.d/postgresql start
#/etc/init.d/vsftpd start
#/etc/init.d/xinetd start
#/etc/init.d/ntp start
exit 0
把
/etc/init.d/apache2 start
/etc/init.d/mysql start
前的#去掉，mysql,apache2,即开机自动启动，
root@bigdataA:/home/zs# netstat -an
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
tcp 0 256 192.168.1.125:22 192.168.1.6:49733 ESTABLISHED
tcp6 0 0 :::80 ::???? LISTEN
tcp6 0 0 :::22 ::???? LISTEN
udp 0 0 192.168.1.125:123 0.0.0.0:*
udp 0 0 127.0.0.1:123 0.0.0.0:*
udp 0 0 0.0.0.0:123 0.0.0.0:*
udp6 0 0 fe80::a8c4:51ff:fe3:123 ::????
udp6 0 0 ::1:123 ::????
udp6 0 0 :::123 ::????
查看启动情况，80，3306,为apache.mysql的端口。自动启动正常。在浏览器中输入：
http://192.168.1.125/a.php
显示php 正常。
修改/var/www/html/下的文件即可进行php开发。
以下进入数据库
root@bigdataA:/home/zs# mysql -v
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 39
Server version: 10.1.41-MariaDB-0+deb9u1 Debian 9.9
Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
切换数据库
MariaDB [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]>
MariaDB [mysql]> SHOW DATABASES;--------------
SHOW DATABASES
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
±-------------------+
2 rows in set (0.00 sec)
MariaDB [mysql]>
MariaDB [mysql]> CREATE DATABASE example;
CREATE DATABASE example
Query OK, 1 row affected (0.00 sec)
MariaDB [mysql]> SHOW DATABASES;
SHOW DATABASES
±-------------------+
| Database |
±-------------------+
| example |
| information_schema |
| mysql |
±-------------------+
3 rows in set (0.00 sec)
MariaDB [mysql]> use example;
MariaDB [example]>CREATE TABLE student (id int,name varchar(20));
CREATE TABLE student (id int,name varchar(20))
Query OK, 0 rows affected (0.11 sec)
…
常用命令：
#pwd
/home/zs
root@bigdataA:/home/zs# cd /root
root@bigdataA:~# ls
查看网络配置
root@bigdataA:~# ifconfig -a
eth0: flags=4163
inet 192.168.1.125 netmask 255.255.255.0 broadcast 192.168.1.255
inet6 fe80::a8c4:51ff:fe3e:aeda prefixlen 64 scopeid 0x20
ether aa:c4:51:3e:ae:da txqueuelen 1000 (Ethernet)
RX packets 4304 bytes 282205 (275.5 KiB)
RX errors 0 dropped 3683 overruns 0 frame 0
TX packets 335 bytes 35961 (35.1 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
device interrupt 24
lo: flags=73
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10
loop txqueuelen 1 (Local Loopback)
RX packets 8 bytes 490 (490.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 8 bytes 490 (490.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
wlan0: flags=4098
ether 28:ed:e0:62:54:0c txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
root@bigdataA:~#
可看到预置的软件，启用即可。
root@bigdataA:/home/zs# nano /etc/rc.local
…
su - zs -c'/md1/apache-tomcat-8.5.35/bin/startup.sh'
#sleep 5
#su - zs -c'pgxc_ctl -c /home/zs/pgxc_ctl/pgxc_ctl.conf start all'
#/etc/init.d/apache2 start
#/etc/init.d/mysql start
#/etc/init.d/bind9 start
#/etc/init.d/postgresql start
#/etc/init.d/vsftpd start
#/etc/init.d/xinetd start
#/etc/init.d/ntp start
exit 0
