linuxDeploy手机配置-记录
废旧手机重获新生
1-ubuntu配置
2-安装mysql
# 安装指令
apt-get install mariadb-server
service mysql start
sudo usermod -aG aid_inet mysql
mysql_secure_installation
service mysql start
mysql -uroot -p
# 默认无密码
更改密码
MariaDB [(none)]> use mysql;
MariaDB [mysql]> UPDATE user SET password=password(‘newpassword’) WHERE user=‘root’;
或者
MariaDB [mysql]> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘newpassword’;
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit;
修改远程连接
## 授权
select host,user,password from user;
grant all privileges on *.* to 'root'@'%' identified by 'root';
#或者
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
生效配置
flush privileges;
# 修改配置
/etc/mysql/mariadb.conf.d/50-server.cnf
将下面这行注掉
#bind-address = 127.0.0.1
navicat链接
3-ngrock内网穿透
试用了可用 ngrock,natapp,小米球等
以小米球为例
小米球地址
需要付费0.5实名认证(相当于免费了)速度还可以