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...
Fri, 1 Oct, 2021 at 9:21 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: I...
Wed, 12 Jul, 2017 at 7:55 PM