1.开启ssh

 设置root密码

passwd

第一步:进入etc>ssh>sshd_config,点击进入,改变IP地址为0.0.0.0
 

vim /etc/ssh/sshd_config

第二步:启动ssh,/etc/init.d/ssh start

/etc/init.d/ssh start

第三步:连接登录,ssh demo@192.168.31.109 -p9022,密码:demo

root用户登录

vim /etc/passwd

第一行为为 

/bin/bash

第一行为root:x: - 1:0: root: /bin/bash

ssh root@192.168.31.109 -p 9022

2、安装mysql

apt-get install default-mysql-server

2.初始化数据

mysql_install_db 

 

3.启动mysql #

service mysql start

4.修改root用户密码 /usr/bin/mysqladmin -u root password '密码'

/usr/bin/mysqladmin -u root password '密码'

导入sql问题

把sql里面COLLATE=utf8mb4_0900_ai_ci改成空的意思是删除这个

2、配置允许远程访问

注意这里有个大坑,Aid Learning 下载的mysql是mysql的一个分支:MariaDB 。

所以我们这里去/etc/mysql/my.cnf 配置是没有用的,

解决办法:

进去mysql目录

cd /etc/mysql

输入命令查看真实的mysql配置地址

grep -rn "skip-networking" *

进入真实的地址把 bin-address注释了

vim /etc/mysql/mariadb.conf.d/50-server.cnf
# bind-address=127.0.0.1

 

远程复制

从远程复制到本机,如果文件夹加-i

scp Administrator@192.168.31.84:G:/adb /home/

3、配置远程访问用户

进入mysql

service mysql start

 

 

配置任何地址都可以访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

刷新配置

FLUSH privileges;  

然后重启mysql服务

service mysql restart

3. aid learning如何换源

 

cd /etc/apt/&&
cp sources.list sources.list.bk&&
echo deb https://mirrors.tuna.tsinghua.edu.cn/debian/ buster main contrib non-free > sources.list&&
echo deb https://mirrors.tuna.tsinghua.edu.cn/debian/ buster-updates main contrib non-free >> sources.list&&
echo deb https://mirrors.tuna.tsinghua.edu.cn/debian/ buster-backports main contrib non-free >> sources.list&&
echo deb https://mirrors.tuna.tsinghua.edu.cn/debian-security/ buster/updates main contrib non-free >> sources.list&&
echo deb-src https://mirrors.tuna.tsinghua.edu.cn/debian/ buster main contrib non-free >> sources.list&&
echo deb-src https://mirrors.tuna.tsinghua.edu.cn/debian/ buster-updates main contrib non-free >> sources.list&&
echo deb-src https://mirrors.tuna.tsinghua.edu.cn/debian/ buster-backports main contrib non-free >> sources.list&&
echo deb-src https://mirrors.tuna.tsinghua.edu.cn/debian-security/ buster/updates main contrib non-free >> sources.list&&
apt update&&
echo 换源已完成!&&
cd /home


复制上面代码,在terminal中,执行一遍,可换为清华源

中科大

deb https://mirrors.ustc.edu.cn/debian/ stretch main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian/ stretch main contrib non-free
deb https://mirrors.ustc.edu.cn/debian/ stretch-updates main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian/ stretch-updates main contrib non-free
deb https://mirrors.ustc.edu.cn/debian/ stretch-backports main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian/ stretch-backports main contrib non-free
deb https://mirrors.ustc.edu.cn/debian-security/ stretch/updates main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian-security/ stretch/updates main contrib non-free

 

 4.写的脚本需要安装得库,

uiautomator2 
pymysql
adbutils
vim PackagesInfo.txt
python -m pip install -r PackagesInfo.txt

连接uiautomator2 如果没有权限,kill-server然后

adb tcpic 5555

 5. crontab

apt-get install cron

然后看crontab教程,切换编辑器,定时