Python2
此文为获取Maya2018在注册表中的路径

import _winreg

string = r'SOFTWARE\Autodesk\Maya\2018\Setup\InstallPath'
handle = _winreg.OpenKey(_winreg.HKEY_LOCAL_MACHINE, string)
location, _type = _winreg.QueryValueEx(handle, "MAYA_INSTALL_LOCATION")
print(location)


Python3

import winreg

string = r'SOFTWAREAutodeskMaya2018SetupInstallPath'
handle = winreg.OpenKey(winreg.HKEY_LOCAL_MACHINE, string, 0, (winreg.KEY_WOW64_64KEY + winreg.KEY_READ))
location, _type = winreg.QueryValueEx(handle, "MAYA_INSTALL_LOCATION")
print(location)

https://www.ip.cn/api/index?ip=221.213.24.219&type=1

{"rs":1,"code":0,"address":"中国  云南省 昆明市 联通","ip":"221.213.24.219","isDomain":0}

https://opendata.baidu.com/api.php?query=221.213.24.219&co=&resource_id=6006&oe=utf8

{"status":"0","t":"","set_cache_time":"","data":[{"ExtendedLocation":"","OriginQuery":"221.213.24.219","SchemaVer":"","appinfo":"","disp_type":0,"fetchkey":"221.213.24.219","location":"云南省昆明市 联通","origip":"221.213.24.219","origipquery":"221.213.24.219","resourceid":"6006","role_id":0,"schemaID":"","shareImage":1,"showLikeShare":1,"showlamp":"1","strategyData":{},"titlecont":"IP地址查询","tplt":"ip"}]}

https://searchplugin.csdn.net/api/v1/ip/get?ip=221.213.24.219

{"code":200,"msg":"success","data":{"address":"中国 云南 昆明 联通","ip":"221.213.24.219"}}

https://ip.useragentinfo.com/jsonp?ip=221.213.24.219

callback({"country": "中国", "short_name": "CN", "province": "云南省", "city": "昆明市", "area": "", "isp": "联通", "net": "城域网", "ip": "221.213.24.219", "code": 200, "desc": "success"});

https://webapi-pc.meitu.com/common/ip_location?ip=121.8.215.106

{"reqid":"8014a00789e5450dc8f4b631817ee2e0","code":0,"data":{"121.8.215.106":{"area_code":"86","city":"广州市","city_id":160063402,"continent":"亚洲","continent_code":"AP","country_id":100000,"isp":"电信","latitude":23.3283,"longitude":113.75837,"nation":"中国","nation_code":"CN","province":"广东","province_id":440000,"subdivision_1_iso_code":"*","subdivision_1_name":"广东","subdivision_2_iso_code":"*","subdivision_2_name":"广州市","time_zone":"UTC+8"}}}

https://api-v3.speedtest.cn/ip?ip=1.2.4.8

{"code":0,"data":{"ip":"1.2.4.*","country":"sDNS","province":"北京市","city":"北京","district":"","isp":"sDNS","operator":"sDNS","countryCode":null,"lon":"0.0","lat":"0.0"},"'msg'":"ok"}

https://apimobile.meituan.com/locate/v2/ip/loc?rgeo=true&ip=1.2.4.8

{"data":{"lng":116.41,"fromwhere":"mars-mt","ip":"1.2.4.8","rgeo":{"country":"中国","province":"北京市","adcode":"110101","city":"北京","district":"东城区"},"lat":39.91}}

U-NAS系统自带的MYSQL。
用mysql连接上,执行show tables，是能看到user表的。
但是更新密码，就报错。

ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

解决方案：

1. 检查 mysql.user 是否是视图
首先，检查 mysql.user 是否是视图。你可以使用以下命令：

SHOW FULL TABLES IN mysql WHERE TABLE_TYPE = 'VIEW';

2. 查看视图定义
如果 mysql.user 是视图，可以通过以下命令查看视图的定义：

SHOW CREATE VIEW mysql.user;

3. 检查权限
确保你有足够的权限来更新 mysql.user 表。你可以查看当前用户的权限：

SHOW GRANTS FOR CURRENT_USER();

执行了查看视图之后，

返回如下信息：

MariaDB [mysql]> SHOW CREATE VIEW mysql.user\G;
*************************** 1. row ***************************
                View: user
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=mariadb.sys@localhost SQL SECURITY DEFINER VIEW user AS select global_priv.Host AS Host,global_priv.User AS User,if(json_value(global_priv.Priv,'$.plugin') in ('mysql_native_password','mysql_old_password'),ifnull(json_value(global_priv.Priv,'$.authentication_string'),''),'') AS Password,if(json_value(global_priv.Priv,'$.access') & 1,'Y','N') AS Select_priv,if(json_value(global_priv.Priv,'$.access') & 2,'Y','N') AS Insert_priv,if(json_value(global_priv.Priv,'$.access') & .........省略

从视图定义中可以看出，mysql.user 视图基于 global_priv 表并从其中提取数据。因此，要更新 mysql.user 视图中的数据，需要直接更新 global_priv 表。

更新 global_priv 表

根据 mysql.user 视图的定义，authentication_string 存储在 global_priv 表的 Priv 列的 JSON 字段中。你需要使用 JSON 操作来更新它。

USE mysql;

-- 更新密码和插件
UPDATE global_priv 
SET Priv = JSON_SET(Priv, '$.authentication_string', '*E9999.......................EEEEE', '$.plugin', 'mysql_native_password') 
WHERE User='root' AND Host='localhost';

-- 刷新权限
FLUSH PRIVILEGES;

-- 检查更新是否成功
SELECT User, Host, JSON_UNQUOTE(JSON_EXTRACT(Priv, '$.authentication_string')) AS authentication_string, JSON_UNQUOTE(JSON_EXTRACT(Priv, '$.plugin')) AS plugin
FROM global_priv
WHERE User='root' AND Host='localhost';

1，ColorOS 12是无法解锁的，要解锁必须先降级。
2，ColorOS 12版本，以前是区分氢氧系统的，国行叫 氢 ，海外叫 氧 。所以降级成11版本，即降级到 氢 11 。
3，https://yun.daxiaamu.com/OnePlus_Roms_2/%E4%B8%80%E5%8A%A07%20Pro/%E9%99%8D%E7%BA%A7%E5%8C%85%E6%B0%A2OS%2011.0.5.1/OnePlus7ProHydrogen_21.H.42_OTA_0420_all_2112212058_downgrade_for_ColorOS_0afdf3c54a0f464a.zip?preview

4，解锁之后就是常规流程了。
下载magisk的APK，patch，安装。
https://github.com/topjohnwu/Magisk/releases/download/v27.0/Magisk-v27.0.apk

以前的是25版本，升级起来比较困难，想着直接跨版本升级吧。
结果发现，数据结构都不一样。

想着重新安装一个，重新扫描文件，入库吧。
29版本把这个files:scan的功能还给删了。卧槽。

又开始安装25.0.13（25的最新版），结果发现跟我以前的不一样了。
填写数据库，必须用MYSQL的root账号，然后自动创建一个oc_admin的mysql账号，这个应用后续会使用oc_admin账号。
因为我之前不知道啊，我还给专门创建了一个mysql账号，一直报错。shit！

好多的插件，安装过程中报错，其实是因为有墙，但是又不明确告诉你是网络问题。只能看日志，才知道。也没有明确的设置代理的地方。