MySQL

MySQL: Error connecting
Connecting to MySQL may result in various errors. See below for some of the most common. The solutions are based on that at least DbVisualizer 12.1.3 is...
Mon, 29 Nov, 2021 at 8:01 AM
MySQL: Value '0000-00-00' can not be represented as java.sql.Timestamp
Accessing a table in the Data tab or in the SQL Commander that contain a DATETIME column sometimes report the following error and highlights the column in...
Mon, 11 Dec, 2017 at 11:12 AM
MySQL: TINYINT's are displayed as a boolean, TRUE/FALSE rather than 1/0
You can override this by changing a driver property for your MySQL connection. Do this in the Properties tab for the connection and in the Driver Properties...
Wed, 12 Jul, 2017 at 7:55 PM
MySQL: Connecting securely to a MySQL server
MySQL supports both encryption and secure authentication. This solution describes how to connect using DbVisualizer to a secured mySQL server. The descripti...
Wed, 17 Feb, 2021 at 11:34 PM
MySQL: Column aliases are not displayed as column headers in result sets
I can't see bar as column header in the result set for the following query. I always get foo. select foo as 'bar' from mytable Solution: In t...
Wed, 12 Jul, 2017 at 7:55 PM