MySQL_setup

$ sudo apt install mysql-server -y  
$ sudo mysql >> to open mysql terminal  

-- Sets local root user's password:
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password in quotes';  

-- Reloads to apply changes & exit mysql: 
    FLUSH PRIVILEGES;   
    EXIT; 

$ sudo mysql -u root -p >> enter password declared above to open & access mysql  

-- To create database if not exisiting already:
    CREATE DATABASE IF NOT EXISTS crud_app;

-- Switch to database:
    USE crud_app;

-- To drop table if needed (optional safety clean up):
    DROP TABLE IF EXISTS users;

-- To create 'users' table with proper structure:
    CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    role ENUM('admin', 'viewer') NOT NULL DEFAULT 'viewer',
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    );
    
    exit;  (exit mysql terminal)