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
mysql> CREATE DATABASE param DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  • Delete database: param
mysql> DROP DATABASE param;
  • List the databases created in the database server
SHOW DATABASES;

User Management

Access Rights Management

Table Management

Backup Management

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