Use the search feature to view Kepware's repository of more than 500 Knowledge Base articles. Narrow your results or type your query into the search field below.

Alternatively, if you are unable to find a solution, we have an additional resource - our PTC eSupport Portal . If you are prompted to log into the eSupport Portal, you can use your My Kepware credentials. Need a My Kepware account? Create one here .

Search Solution Results By:
View All Solutions

Kepware Knowledge Base: Solution


Accessing a MySQL Database Running on a Linux/Unix Computer


Last Update: 11/12/2018

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