How to Easily Backup MySQL Database 1. Overview In this short tutorial, we'll see how to John D K Feb 17, 2022 1 min read
How To Create a New User and Grant Permissions in MySQL 1. Overview In this tutorial, we'll show how to create John D K Feb 16, 2022 2 min read
MySQL 8 Access denied for user 'root'@'localhost' Quick solution for MySQL 8 (and MySQL 5.7) error: John D K Oct 24, 2019 2 min read
How to reset user password Ghost 2 blog MySQL If you forgot your Ghost blog password and you don't John D K Jul 5, 2019 2 min read
MySQL Workbench 8 unsupported operating system for Linux Mint After installation of latest MySQL Workbench downloaded directly from the John D K Aug 24, 2018 1 min read
MySQL 8 Set or reset user password Reset of MySQL password can be done in several ways John D K Apr 15, 2018 4 min read
MySQL convert column to row unpivot example In this post simulate pivot and unpivot in MySQL: * Step John D K Feb 22, 2018 1 min read
How To Install MySQL 8 on Ubuntu 16.04 In this post: * Install default MySQL version (ritht now 5. John D K Feb 15, 2018 2 min read
MySQL: VARCHAR or TEXT for long text fields In this post: * Varchar vs Text use cases * Varchar vs John D K Sep 15, 2017 2 min read
Remote Connection to MySQL with SSH tunnel to Ubuntu 16 Simple connection with terminal mysql -u {username} -p{password} -h John D K Sep 4, 2017 3 min read
How to rename MySQL schema - the proper way Renaming a MySQL schema depends on several constraints: * database size; John D K Sep 4, 2017 3 min read
Ubuntu 18.04 How to Install, Reinstall and Uninstall MySQL In this post you can find information about Ubuntu 18. John D K Aug 21, 2017 4 min read