在线体验
环境地址：https://open-yuqing.stonedt.com/
docker run -itd --name stonedt_yuqing -p 8085:8085 registry.cn-beijing.aliyuncs.com/stonedt_yuqing/stonedt_yuqing:1.0.7访问地址 http://ip:8085 用户名13900000000 密码stonedt
完成
账号已过期！
注意，默认的账号会过期，并且没有地方配置过期时间，莫慌
跟我操作
进入容器登陆数据库
# mysql -uroot -p123456
查看当前数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| stonedt_portal |
| sys |
+--------------------+
5 rows in set (0.04 sec)
进入stonedt_portal库
mysql> use stonedt_portal;
Database changed
列出表
mysql> show tables;
+--------------------------+
| Tables_in_stonedt_portal |
+--------------------------+
| data_favorite |
| systemlog |
| user |
查看user表
mysql> select * from user;
+----+---------------------+-------------+-------------+----------------------------------+--------------------+---------------------+--------+----------+---------------+--------+-------------+----------+-----------------+-----------+------------+------------+-----------+---------------+----------------+----------+---------------+----------------+----------+---------------------+-----------+
| id | create_time | user_id | telephone | password | email | end_login_time | status | username | wechat_number | openid | login_count | identity | organization_id | user_type | user_level | wechatflag | is_online | nlp_secret_id | nlp_secret_key | nlp_flag | xie_secret_id | xie_secret_key | xie_flag | term_of_validity | mail_json |
+----+---------------------+-------------+-------------+----------------------------------+--------------------+---------------------+--------+----------+---------------+--------+-------------+----------+-----------------+-----------+------------+------------+-----------+---------------+----------------+----------+---------------+----------------+----------+---------------------+-----------+
| 97 | 2022-02-14 11:23:13 | 13900000000 | 13900000000 | xx | 13900000000@qq.com | 2025-01-17 12:06:40 | 1 | NULL | NULL | NULL | 132 | NULL | NULL | 3 | NULL | NULL | 1 | NULL | NULL | 0 | NULL | NULL | 0 | 2025-01-19 00:00:00 | NULL |
可以看到term_of_validity上个月就过期了，改一下，改到2099年
mysql> UPDATE user SET term_of_validity='2099-01-19 00:00:00' WHERE id=97;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
登陆成功，修改完成
评论