使用搜索功能查看 Kepware 的信息库,其中包含 500 多篇知识库文章。缩小搜索结果范围,或在下面的搜索字段中输入您的查询。

或者,如果您无法找到解决方案,我们还有另一个资源:我们的 PTC eSupport Portal。 如果系统提示您登录 eSupport Portal,您可以使用“我的 Kepware”凭据。需要一个“我的 Kepware”帐户吗?在此处创建

搜索解决方案结果:
View All Solutions

Kepware Knowledge Base: Solution


Accessing a MySQL Database Running on a Linux/Unix Computer


Last Update: 2018/11/12

To access a MySQL database running on a Linux/Unix computer, users must first configure the database to allow access from remote PCs. For more information, refer to the instructions below.

  1. To start, launch a terminal window.
  2. Next, run "mysql –uUsername –p".
  3. Then, log in and enter the following:

    mysql> GRANT ALL ON *.* TO 'Username'@'%' IDENTIFIED BY 'password';
    Query OK, 0 rows affected (0.14 sec)
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.16 sec)
    mysql> \q\
    Bye

  4. On the Windows PC, install the "mysql-connector-odbc-3.51.12-win32.zip" file from the MySql website.

Note: This will allow the configuration of an ODBC DSN to the MySQL database.

Related Products
DataLogger, ODBC Client