ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 在海之舟大数据平台上搭建mysql+php开发平台

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

原创 Linux操作系统 作者:wxh585 时间:2019-10-10 11:31:24 0 删除 编辑


海之舟服务器操作系统基于国产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<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


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23102655/viewspace-2659319/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2019-10-10

  • 博文量
    4
  • 访问量
    961