Fix 'Public Key Retrieval is not allowed' in MySQL JDBC
Fix MySQL JDBC 'Public Key Retrieval is not allowed': why caching_sha2_password causes it and when to use TLS, a pinned key or allowPublicKeyRetrieval.
Mysql
Every post tagged mysql on the DbSchema blog.
MySQL JDBC URL and Connection String Parameters
The MySQL JDBC URL format, localhost and multi-host examples, and the connection properties worth setting: sslMode, connectionTimeZone and timeouts.
How to Rename a MySQL Database Using mysqldump | DbSchema
MySQL has no RENAME DATABASE statement. Dump, create the target, restore, verify table and row counts, drop the original, and fix what did not follow.
How to Run MySQL in Docker Step by Step | DbSchema
Run MySQL in Docker with one docker run command, persist data in a named volume, connect from the host and from DbSchema, and fix common startup errors.
MySQL DROP CONSTRAINT Foreign Key, Unique, Check, and Primary Key Syntax | DbSchema
Learn MySQL DROP CONSTRAINT patterns for 5.7, 8.0, and 8.4. Remove foreign keys, unique indexes, checks, and primary keys safely in DbSchema.
MySQL ER Diagram, Reverse Engineer and Design Schemas Visually | DbSchema
Create a MySQL ER diagram from an existing database or design one from scratch. See version-aware examples, docs links, and DbSchema workflow tips.
MySQL CREATE TRIGGER Syntax, BEFORE/AFTER Examples, and Audit Patterns | DbSchema
Learn MySQL CREATE TRIGGER syntax for 5.7, 8.0, and 8.4 with BEFORE/AFTER examples, audit trail patterns, validation logic, and DbSchema tips.
Best MySQL Database Design Tools in 2026: Buyer's Comparison
Seven MySQL design tools compared on engines, reverse engineering, offline use, documentation, Git and prices, with what each one is built for and where DbSchema fits.
MySQL Default Username and Password | DbSchema
Find the real MySQL default root login behavior for 5.7, 8.0, and 8.4, reset passwords safely, and secure access faster with DbSchema.
MySQL DROP DATABASE Guide with Safety Checklist | DbSchema
Learn how to drop a MySQL database safely, verify deletion, and manage the operation visually in DbSchema.
A Visual Query Builder for MySQL: The Data Analyst Guide
Learn how a visual query builder for MySQL helps data analysts explore unlimited tables, build complex queries, and analyze data without writing raw SQL.
ERD Diagrams | MySQL Database Design and Docs with DbSchema
Design MySQL ER diagrams in DbSchema, edit the schema visually, and generate interactive HTML5 documentation from the model.
Reverse Engineering a MySQL Database: A Developer's Guide
Learn how to reverse-engineer a MySQL database to extract its structure, handle missing MyISAM foreign keys, and build an interactive ER diagram offline.
MySQL INSERT INTO Guide with Practical Examples | DbSchema
Learn how to insert data into MySQL tables with SQL examples and visual data import workflows in DbSchema.
How to Document a MySQL Database Schema in 2026
Learn how to document your MySQL database schema in 2026 using modern tools for diagrams, data dictionaries, and interactive HTML documentation.
MySQL Schema Version Control: Git Workflows and Diffs
Learn how to implement MySQL schema version control by saving your design model as an XML file in Git, reviewing diffs, and generating migration scripts.
MySQL Create User CREATE USER, GRANT, Roles, and Host Examples | DbSchema
Learn MySQL CREATE USER and GRANT syntax for 5.7, 8.0, and 8.4, including localhost, wildcard hosts, roles, and secure privilege examples.
MySQL CREATE TABLE Guide with Examples | DbSchema
Learn how to create tables in MySQL with SQL commands, prerequisites, and visual design steps in DbSchema.
Documenting a MySQL Database
Learn how to generate interactive MySQL database documentation. Compare top tools, explore the four documentation types, and export HTML5 docs.
MySQL CREATE DATABASE Guide for Beginners | DbSchema
Learn how to create a MySQL database from the command line, verify it, and manage it visually in DbSchema.