lefatoum2/MySQL-Commander

MySQL-Commander

https://blog.devart.com/mysql-command-line-client.html

C:\Program Files\MySQL\MySQL Server 8.0\bin

mysql -u root -p

Creating User

https://blog.devart.com/how-to-create-a-new-user-and-grant-privileges.html

CREATE USER 'username' IDENTIFIED BY 'password';

GRANT SELECT ON . TO 'username';

GRANT ALL PRIVILEGES ON . TO 'username';

Deleting a user

DROP USER 'username';

Creating a databases

CREATE DATABASE dbname;

show database

USE dbname;

Deleting a database

DROP DATABASE dbname;

Creating tables

show tables

Help

help or \h