yejr

知识库采用文本文件形式，可编辑，格式如下： 分组空间（群名称) # 匹配关键字（或正则表达式） # 回复内容 __全局__         #   你好                      # 很高兴认识 __我的好友__     #   多谢                      # 不客气 我的群组1        #   今天天气怎么样            # 没有雨\n不用带伞 （\n表示换行） 在这里，“我的群组1”可否也增加支持正则表达的功能呢，谢谢。

check some $_GET args for security reason(XSS and SQL Injection)

1

check some $_GET args for security reason(XSS and SQL Injection)

show record details in specify page like innodb_space page-dump

1

like innodb_space example: ``` $ innodb_space -s ibdata1 -T innodb/t1 -p 3 page-dump ... records: {:format=>:compact, :offset=>127, :header=> {:next=>263, :type=>:conventional, :heap_number=>2, :n_owned=>0, :min_rec=>false, :deleted=>false, :nulls=>[], :lengths=>{"c2"=>36, "c3"=>72}, :externs=>[], :length=>7}, :next=>263,...

In the USER management operation, when the hostname is not specified, it cannot be automatically set to%

5

``` mysql>create user yejr identified by 'xx'; -- hostname is not specified, treated as% Query OK, 0 rows affected (0.12 sec) mysql>show grants for yejr; -- hostname is not specified,...

mysql client occasionally encounters errors

1

``` mysql> show create table t1; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | TABLE | CREATE TABLE | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `score` tinyint(4) NOT NULL,...

can not dump all database by mysqldump

3

polardb-x cluster was created via: ``` $ pxd tryout -cn_replica 2 -cn_version latest -dn_replica 2 -dn_version latest -cdc_replica 2 -cdc_version latest ``` dump data by mysqldump ``` $ mysqldump -t...

How to customize the port when deploys polardb-x cluster by pxd

2

ref doc: https://www.polardbx.com/document How to customize the port number when editing the polardb-x cluster topology definition YAML file?

How to change password for user `polardbx_root`

1

``` mysql>select user(); +--------------------------+ | USER() | +--------------------------+ | [email protected] | +--------------------------+ 1 row in set (0.00 sec) mysql>select current_user(); +----------------+ | current_user() | +----------------+ | d1@pxc-tryout | +----------------+ 1...

不支持show all tables语法

3

* **dble version：** 5.7.11-dble-3.22.07.0-891dd27f53e35a30166179d79d1dfadd5f2719da-20220915062343 * **安装方式** 参考文档：https://github.com/actiontech/dble-docs-cn/blob/master/0.overview/0.3_quick_start/0.3.1_dble_quick_start_docker.md 安装过程： ``` docker network create -o "com.docker.network.bridge.name"="dble-net" --subnet 172.18.0.0/16 dble-net docker run --name backend-mysql1 --ip 172.18.0.2 -e MYSQL_ROOT_PASSWORD=123456 -p 33061:3306 --network=dble-net -d mysql:5.7...

* **dble version：** ``` man1@[dble_information]>show @@version; +-------------------------------------------------------------------------------+ | VERSION | +-------------------------------------------------------------------------------+ | 5.7.11-dble-3.22.07.0-891dd27f53e35a30166179d79d1dfadd5f2719da-20220915062343 | +-------------------------------------------------------------------------------+ 1 row in set (0.00 sec) ``` 参考文档：https://github.com/actiontech/dble-docs-cn/blob/master/2.Function/2.1_manager_cmd/2.1.03_show.md#21340--show-shardingnodes-where-schema-and-table： ``` # 提示不支持的语法，还以为是不支持该功能 man1@[dble_information]>show @@shardingNodes; ERROR 1003...