Mysql Commands

From The Opensource Knowledgebase
Jump to navigation Jump to search

Installation

  • Installation on ubuntu server through terminal

sudo apt install mariadb-server sudo mysql_secure_installation sudo systemctl status mariadb

  • Start or stop mariadb server services

sudo systemctl stop mariadb sudo systemctl start mariadb

Database Management

  • Create database: param
    • Using defaults
mysql> CREATE DATABASE param;
  • Using specific parameters one can change the parameters based on requirement
mysql> CREATE DATABASE param DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  • Delete database: param
mysql> DROP DATABASE param;

User Management

Access Rights Management

Table Management

Backup Management

Retrieved from "https://infrastructure-advisory.org/index.php?title=Mysql_Commands&oldid=131"