Download for free
Software Installation ubuntudebian beginner

Install MySQL

Install MySQL Server

Overview

Install MySQL Server

Commands

This will install MySQL Server, continue?

sudo apt-get update && sudo apt-get install -y mysql-server
sudo systemctl enable --now mysql

Use Cases

Business database storage, WordPress/Typecho blog setup.

Prerequisites

Memory >= 512MB; run security configuration sudo mysql_secure_installation first.

FAQ

  • Cannot log in as root without password → enter via sudo mysql and change the authentication method
  • Character set issue → configure /etc/mysql/mysql.conf.d/mysqld.cnf and add character-set-server=utf8mb4
  • Restart MySQL
  • Export MySQL Database
  • Import MySQL Database