Please enable JavaScript to view this site.

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 of your MySQL data source set the following values:
 

5.1. Certificate Store Location: CurrentUser
 

5.2. SSL Mode: Required

 

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

When you have that type of error while attempting to edit or add a new entry on a MySQL database the problem is because your Advanced settings have been modified.

 

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

 

CacherServerProperties Default Value

CacherServerProperties Default Value

 

Erase the Value of the CacheServerProperties field.