Home > database >  On the boat of the sea server operating system structures, mysql, PHP development platform
On the boat of the sea server operating system structures, mysql, PHP development platform

Time:09-17

The boat of the sea server operating system, based on domestic arm64 3399 CPU, the points a, b), a version built a large number of software, development interface paradigm,

Operating system is a. Img files, brush into the tf card, under Windows 7 boot can start, start the SSH after landing, the operating interface is as follows,
Powered up for configuration file Settings
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/setups bind9 start
#/etc/init. D/postgresql start
#/etc/init. D/VSFTPD start
#/etc/init. D/xinetd start
#/etc/init. D/NTP start
The exit 0

The
The/etc/init. D/apache2 start
The/etc/init. D/mysql start
# remove, mysql, apache2, namely boot automatically start,

Root @ bigdataA:/home/zs# netstat - an
An Active Internet connections (the servers and established)
The Send Proto Recv - Q - 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:51 ff: fe3:123: :??
Udp6 0:0:3:1:12:??????
Udp6 0 0: : : 123: :??
Look at startup, 6, 80330. For apache mysql port, automatic start normal, enter in your browser:
http://192.168.1.125/a.php

Display the PHP normal,
Modify the/var/WWW/HTML/PHP file,

The following into the database
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 the history - the file/root/. Mysql_history
Type 'help; 'or' h \ 'for help. The Type' \ c to clear the current input statement.
Switch the
MariaDB [(none)] & gt; The use of mysql
Reading the table information for the completion of the table and column names
You can turn off this feature to get a quicker startup with - a

The Database changed
MariaDB/mysql & gt;
MariaDB/mysql & gt; SHOW the DATABASES; -- -- -- -- -- -- -- -- -- -- -- -- -- --
SHOW the DATABASES
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| Database |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| information_schema |
| mysql |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
2 rows in the set (0.00 SEC)

MariaDB/mysql & gt;
MariaDB/mysql & gt; The CREATE DATABASE example.
The CREATE DATABASE example

Query OK, 1 row affected (0.00 SEC)

MariaDB/mysql & gt; SHOW the DATABASES;

SHOW the DATABASES

+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| Database |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| example |
| information_schema |
| mysql |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
3 rows in the set (0.00 SEC)

MariaDB/mysql & gt; Use the example;
MariaDB [example] & gt; Int the CREATE TABLE student (id, name varchar (20));

Int the CREATE TABLE student (id, name varchar (20))

Query OK, 0 rows affected (0.11 SEC)

...
Commonly used commands:
# PWD
/home/zs
Root @ bigdataA:/home/zs# CD/root
Root @ bigdataA: ~ # ls
Check the network configuration
Root @ bigdataA: ~ # ifconfig -a
Eth0: flags=4163 & lt; The UP, the BROADCAST, RUNNING, MULTICAST> Mtu 1500
Inet 192.168.1.125 netmask 255.255.255.0 broadcast 192.168.1.255
Inet6 fe80: : a8c4:51 ff: fe3e: aeda prefixlen 64 scopeid 0 x20
Mr Aa: c4: her e: ae: da txqueuelen 1000 (Ethernet)
RX packets 4304 bytes (275.5 282205 KiB)
RX errors overruns frame 0 0 0 dropped 3683
TX packets 335 bytes (35.1 35961 KiB)
TX errors 0 dropped overruns carrier collisions 0 0 0 0
Device interrupt 24

Lo: flags=73 & lt; UP, LOOPBACK RUNNING> Mtu 65536
Inet 127.0.0.1 netmask 255.0.0.0
Inet6: : 1 prefixlen 128 scopeid 0 x10
Loop txqueuelen 1 (Local Loopback)
RX packets 8 bytes 490 (490.0 B)
RX errors 0 dropped overruns frame 0 0 0
TX packets 8 bytes 490 (490.0 B)
TX errors 0 dropped overruns carrier collisions 0 0 0 0

Wlan0: flags=4098 & lt; BROADCAST, MULTICAST> Mtu 1500
Mr 28: Ed: e0:62:54:0 txqueuelen c 1000 (Ethernet)
The RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped overruns frame 0 0 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped overruns carrier collisions 0 0 0 0

Root @ bigdataA: ~ #
You can see the preset software, can be enabled,
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/setups bind9 start
#/etc/init. D/postgresql start
#/etc/init. D/VSFTPD start
#/etc/init. D/xinetd start
#/etc/init. D/NTP start
The exit 0