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.
- To start, launch a terminal window.
- Next, run "mysql uUsername p".
- 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
- 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.
©
2022
PTC Inc. All Rights Reserved.