Create MySQL configuration script

APEX-JHOSEF-CARDICH-PALMA / online-shop

The main goal of this repository is to gain experience by practicing. Online shop it's a web app composed of a Node.js API, Angular Front, MySql DB.

0 stars 0 forks source link

Create MySQL configuration script #2

Closed siwonpawel closed 4 years ago

siwonpawel commented 4 years ago

Create MySQL configuration containing:

[x] custom database
[x] user account creation
[x] right access control rights to newly created database that's allows to manipulate database objects and remote login

siwonpawel commented 4 years ago

CREATE DATABASE online_shop; CREATE USER osuser@'localhost' IDENTIFIED BY @@password; GRANT SELECT, INSERT, UPDATE ON online_shop.* TO osuser@'localhost';

keep in mind that @@password is just a mock - enter your own password for the account