如何同时连接多个数据库，都是mysql

[fairyredfox]

如何同时连接多个数据库实例，都是mysql的，同时配置多个？

[wenb1n-dev]

没有限制的哦,只是需要有一个default，其他的根据自己的类型，定义连接池名称即可：

{
  "default": {
    "host": "192.168.xxx.xxx",
    "port": 3306,
    "user": "root",
    "password": "root",
    "database": "a_llm",
    "role": "readonly",
    "pool_size": 10,
    "max_overflow": 20,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "mysql"
  },
    "mysql1": {
    "host": "192.168.xxx.xxx",
    "port": 3306,
    "user": "root",
    "password": "root",
    "database": "a_llm",
    "role": "readonly",
    "pool_size": 10,
    "max_overflow": 20,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "mysql"
  },
  "mysql2": {
    "host": "192.168.xxx.xxx",
    "port": 3306,
    "user": "root",
    "password": "root",
    "database": "a_llm",
    "role": "readonly",
    "pool_size": 10,
    "max_overflow": 20,
    "pool_recycle": 3600,
    "pool_timeout": 30,
    "type": "mysql"
  }
}

[wenb1n-dev]

如果不希望配置多个的话，需要default有对应实例权限，可以根据描述：查询数据库为：xxx的数据，即可。

[mjh568412187]

hi，大佬，如果再一个mysql实例下，配置多个库，有没有简便方法现在使用的是
{
"default": {
"host": "10.xxxxx",
"port": 3306,
"user": "root",
"password": "xxxxx",
"database": "school",
"role": "readonly",
"pool_size": 10,
"max_overflow": 20,
"pool_recycle": 3600,
"pool_timeout": 30,
"type": "mysql"
},
"mysql1": {
"host": "10.xxxx",
"port": 3306,
"user": "root",
"password": "xxxxxxxx",
"database": "business",
"role": "readonly",
"pool_size": 10,
"max_overflow": 20,
"pool_recycle": 3600,
"pool_timeout": 30,
"type": "mysql"
}
}

[wenb1n-dev]

配置一个就行了，然后提问的时候带上库名即可，例如：查询数据库为school的xxx表数据。查询数据库为business的xxx表数据