daily-mysql.md 566 B
title: "Mysql Commands" date: 2021-06-08T17:45:30+07:00 draft: false
tags: []
mysql> DESCRIBE business.student;
mysql> DESC business.student;
mysql> show create table business.student;
用户和授权
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT privileges ON database.table TO 'username'@'host';
# 举例
CREATE USER 'admin'@'localhost' IDENTIFIED BY '123456';
GRANT all ON *.* TO 'admin'@'localhost'
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
GRANT SELECT,INSERT ON test.user TO 'admin'@'%'