Mysql Commands: Difference between revisions
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
*Delete database: param | *Delete database: param | ||
: <code> mysql> DROP DATABASE param;</code> | : <code> mysql> DROP DATABASE param;</code> | ||
*List the databases created in the database server | |||
: <code> showdatabases; </code> | |||
=User Management= | =User Management= | ||
Revision as of 12:44, 10 January 2020
Installation
- Installation on ubuntu server through terminal
sudo apt install mariadb-serversudo mysql_secure_installationsudo systemctl status mariadb
- Start or stop mariadb server services
sudo systemctl stop mariadbsudo 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;
- List the databases created in the database server
showdatabases;