#mysql category
Here you will find the best stories and professional advices from our team
![`img for SQL Query Optimization: Understanding Key Principle article`](https://s.hinty.io/Y9ob8zeXVQSKi33UJL9cvW.jpg)
SQL Query Optimization: Understanding Key Principle
Check if mysql is installed on Ubuntu
![`img for How to create a database in MySQL CLI article`](https://s.hinty.io/KwcbuTJECVEaywxsGUEtZ3.png)
How to create a database in MySQL CLI
![`img for How to backup SQL Database [Simple ready to use script] article`](https://s.hinty.io/DCjmv7rxsm3YyzJyhivhir.png)
How to backup SQL Database [Simple ready to use script]
![`img for How to reset mysql root password on ubuntu article`](https://s.hinty.io/KLFkTRbqYDt6d7o9s7d5jB.png)
How to reset mysql root password on ubuntu
Drop all tables without dropping database
Change mysql database character set to utf8
Dump and restore zipped DB
Create database and user mysql