MySQL

MySQL 8.0 ships with: SSL/TLS enabled by default caching_sha2_plugin authentication DBD::mysql by default: Has SSL/TLS disabled This results in the connection failing as the caching_sha2_plugin needs either SSL/TLS or RSA for the initial connection. Once the server has the entry in the cache secure connections are not required. What the user has to do is:… weiterlesen »

SELECT TABLE_SCHEMA,Round(Sum(data_length + index_length) / 1024 / 1024 / 1024, 2) ‚DBsizeGB‘ FROM information_schema.tables \ GROUP BY TABLE_SCHEMA \ ORDER BY DBsizeGB DESC;