We have a Linux Vm which is running our OTRS. I have found the kernel file which has the database configuration details. In there the host name is listed as local host.
我们有一台运行OTRS的Linux Vm。我找到了具有数据库配置详细信息的内核文件。在那里，主机名列为本地主机。
I tried using the server IP address along with the database username that is there; however I cannot seem to connect.
我尝试使用服务器IP地址以及那里的数据库用户名;但我似乎无法连接。
I also cannot find the port that is utilized. How do I connect to the database on mysqlworkbench,
我也找不到使用的端口。如何在mysqlworkbench上连接数据库，
1 个解决方案
#1
0
Maybe server doesn't allow remote connections to the DB or user used by OTRS is only a local user? If this is true you've got two options:
也许服务器不允许远程连接到数据库，或者OTRS使用的用户只是本地用户？如果这是真的，你有两个选择：
- Create user that is allowed to login remotelyCreate user that is allowed to login remotely
- 创建允许远程登录的用户创建允许远程登录的用户
- Create user that is allowed to login remotely Use Standart (TCP/IP) over SSH as connection method in MySQL workbench. This option allows to first connect over SSH to the server and than connect to the DB as local user
- 创建允许远程登录的用户通过SSH使用Standart（TCP / IP）作为MySQL工作台中的连接方法。此选项允许首先通过SSH连接到服务器，然后以本地用户身份连接到数据库
#1
0
Maybe server doesn't allow remote connections to the DB or user used by OTRS is only a local user? If this is true you've got two options:
也许服务器不允许远程连接到数据库，或者OTRS使用的用户只是本地用户？如果这是真的，你有两个选择：
- Create user that is allowed to login remotelyCreate user that is allowed to login remotely
- 创建允许远程登录的用户创建允许远程登录的用户
- Create user that is allowed to login remotely Use Standart (TCP/IP) over SSH as connection method in MySQL workbench. This option allows to first connect over SSH to the server and than connect to the DB as local user
- 创建允许远程登录的用户通过SSH使用Standart（TCP / IP）作为MySQL工作台中的连接方法。此选项允许首先通过SSH连接到服务器，然后以本地用户身份连接到数据库