在海之舟大数据平台上搭建mysql+php开发平台

海之舟服务器操作系统基于国产arm64,3399cpu，分a版，b版，a版内置了大量软件，开发接口范例。下图为1千多元的套件.含操作系统，服务器、电源。

操作系统是个.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<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 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<UP,LOOPBACK,RUNNING> mtu 65536 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<BROADCAST,MULTICAST> mtu 1500 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