Online Help > Support/Resources > Troubleshooting > Data Sources

Troubleshooting MySQL

Errors

 

Connecting to MySQL using a private certificate

1.Create SSL keys as described in Creating SSL Certs
 

2.Create a client certificate.
 

2.1.openssl pkcs12 -export -in client-cert.pem -inkey client-key.pem -certfile cacert.pem -out client.pfx
 

3.Grant privileges to the user as described in Grant Syntax
 

3.1.GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost' IDENTIFIED BY 'goodsecret' REQUIRE SSL;
 

4.Run certmgr.msc and import the client certificate in the user store
 

5.In the advanced settings or your MySQL data source set the following values
 

5.1.Certificate Store Location: CurrentUser
 

5.2.SSL Mode: Required

 

Error when edit entry "MySql.Data.MySqlClient.MySqlException (0x80004005): Packets larger than max_allowed_packet are not allowed."

When you have that type of error when you try to edit or add a new entry on a MySQL database the problem is because your Advanced Setting had been modified.

 

The resolution is to Edit your database, Select the Advanced tab and go to Advanced Settings.

 

CacherServerProperties Default Value

CacherServerProperties Default Value

 

Erase the Value of the CacheServerProperties field.