aidlearning安装MySQL报错_试玩Aid Learning

前言

记录一下步骤

下载安装

切换源

## 打开Terminal复制回车即可

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

安装Mysql

# 1.安装

apt install default-mysql-server

# 2.初始化数据

mysql_install_db

# 3.启动mysql

service mysql start

# 4.修改root用户密码

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

# 5.登录mysql

mysql -u root -p

# 6.开启root用户远程访问权限(P@ssw0rd填root的密码)

## 写入权限

grant all on *.* to root@‘%‘ identified by ‘P@ssw0rd‘ with grant option;

## 刷新权限并退出

flush privileges;

quit;

# 7.编辑配置文件

vim /etc/mysql/mariadb.conf.d/50-server.cnf

# 8.修改

bind-address=0.0.0.0

# 9. 重启mysql

kill -9 `pgrep mysql`

service mysql start

## 问题一:每次启动都会报错.回车一下就行(有没有大佬知道怎么解决的QAQ)

## 问题二:不能自动启动

安装JDK&Tomcat

安装Ngrok

重启需启动

a.mysql

service mysql start

b.tomcat

/url/local/tomcat8/bin/startup.sh

c.ngrok

1. 使用screen打开新窗口

screen -S aaa

2. 启动服务

/usr/local/ngrok http 10000

3. 后台运行

ctrl + a + d

4. 查看后台运行

screen -r aaa