Differences

This shows you the differences between two versions of the page.

sqldata_mysql_connection [December 04, 2017 3:14 am]
sqlines
sqldata_mysql_connection [November 21, 2020 1:21 am] (current)
sqlines
Line 10: Line 10:
    * ///usr/lib64/mysql/libmysqlclient.so//     * ///usr/lib64/mysql/libmysqlclient.so//
  * **Windows:** (Drive letter and version can be different)   * **Windows:** (Drive letter and version can be different)
 +    * //C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.dll//
    * //C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll//     * //C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll//
    * //C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.dll//     * //C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.dll//
Line 48: Line 49:
  * MySQL C API is not installed. Downlaod and install MySQL C API client at http://dev.mysql.com/downloads/connector/   * MySQL C API is not installed. Downlaod and install MySQL C API client at http://dev.mysql.com/downloads/connector/
-  * MySQL C API is installed but SQLines Data tool cannot find //libmysql.dll// for some reason. Add the directory where  //libmysql.dll// is located (for example, //C:\Program Files\MySQL\MySQL Connector C 6.1\lib//)  to the PATH environment variable and **restart** SQLines Data tool.+  * MySQL C API is installed but SQLines Data tool cannot find //libmysql.dll// for some reason. Add the directory where  //libmysql.dll// is located (for example, //C:\Program Files\MySQL\MySQL Connector C 6.1\lib//)  to the PATH environment variable
 + 
 +  * If you run SQLines Data on MySQL 8.x server host and do not use MySQL Connector C, make sure that **both** //C:\Program Files\MySQL\MySQL Server 8.0\lib// and //C:\Program Files\MySQL\MySQL Server 8.0\bin// are added to the PATH environment variable. \\ \\ The reason is that although //libmysql.dll// in located in //lib// directory, it still needs //libssl-1_1-x64.dll// and //libcrypto-1_1-x64.dll// located in the //bin// directory.
   
To set the PATH variable on Windows, right-click the Computer icon, select Properties, click the Advanced System Settings. Then select Advanced tab and click the Environment Variables button. Go to System Variables, find and append Path. To set the PATH variable on Windows, right-click the Computer icon, select Properties, click the Advanced System Settings. Then select Advanced tab and click the Environment Variables button. Go to System Variables, find and append Path.
 +
 +**Note**. You have to **restart** SQLines Data tool after modifying the PATH environment variable.
Contact us at [[support@sqlines.com]] if you still have any connection problems. Contact us at [[support@sqlines.com]] if you still have any connection problems.