查看版本
SELECT VERSION();
显示端口
SHOW GLOBAL VARIABLES LIKE 'PORT';
------------------------------------------------------
创建用户
CREATE USER 'lxs'@'%' IDENTIFIED BY '123';
赋予权限
GRANT ALL PRIVILEGES ON *.* TO 'lxs'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;
撤销权限
REVOKE ALL PRIVILEGES on *.* FROM 'lxs'@'%';
REVOKE GRANT OPTION ON *.* FROM 'lxs'@'%';
显示权限
SHOW GRANTS FOR 'lxs'@'%';
-----------------------------------------------------
查看表结构
desc mysql.user;
查看用户
select host,user from mysql.user;
查看权限
select * from mysql.user where user='lxs';
删除用户
drop user lxs
mysql 命令随便记记
于 2022-07-08 14:27:59 首次发布