I have set up a DB on my internet providor’s cPanel MySQL which I want to have any PC, anywhere, to have access, readonly, as a licence server. I have been given the server IP address by my ISP and have specified two users each with their own passwords (in cPanel).
A reference in my project is;
MySQL.Data ver 8.0.30.0 C:Program Files (x86)MySQLMySQL Installer for WindowsMySQL.Data
My VB.NET code to open this DB is;
Imports MySql.Data.MySqlClient
Public Class Form1
'Admin login
Private con As New MySqlConnection("server=185.20.51.238;user=silverfern_admin;password=**AdminPasword**;database=silverfern_LicenceServer;")
'etc
end class
This produces an error:
The type initializer for ‘MySql.Data.MySqlClient.MySqlConnectAttrs’ threw an exception.
This DB use is all new to me so any comments would be gratefully received