Mysql Commands: Difference between revisions
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
=User Management= | =User Management= | ||
* Show users | |||
<code> MariaDB [(none)]> mysqlselect host, user, password from mysql.user; </code> | |||
* Show grants to a user | |||
<code> MariaDB [(none)]> HOW GRANTS FOR 'dbusername'@'%'; </code> | |||
Here dbusername is the name of the user that is used to handle database access | |||
*Revoke all grants to a user | |||
<code> MariaDB [(none)]> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'dbusername'@'%'; </code> | |||
*Delete a user | |||
<code> MariaDB [(none)]> DROP USER 'dbusername'@'%'; </code> | |||
=Access Rights Management= | =Access Rights Management= | ||
=Table Management= | =Table Management= | ||
=Backup Management= | =Backup Management= | ||
Revision as of 08:35, 13 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
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
- Show users
MariaDB [(none)]> mysqlselect host, user, password from mysql.user;
- Show grants to a user
MariaDB [(none)]> HOW GRANTS FOR 'dbusername'@'%';
Here dbusername is the name of the user that is used to handle database access
- Revoke all grants to a user
MariaDB [(none)]> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'dbusername'@'%';
- Delete a user
MariaDB [(none)]> DROP USER 'dbusername'@'%';