Mysql

ADMIN

DB 정보

-- 변수정보(버전정보)
show variables like 'version';
-- DB정보
show databses;
show tables;

테이블 상세정보

DESC user;

유저정보

use mysql;

select * from user;

권한부여

GRANT ALL privileges ON DB명.* TO 계정아이디@locahost IDENTIFIED BY '비밀번호';
-- version 호환
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

DDL

DML