Skip to content

Latest commit

 

History

History
executable file
·
15 lines (8 loc) · 583 Bytes

数据库常用命令.md

File metadata and controls

executable file
·
15 lines (8 loc) · 583 Bytes

添加用户：CREATE USER 'fengj_test'@'%' identified by 'fengj_Test';

授权：GRANT ALL PRIVILEGES ON fengj_test.* TO 'fengj_test'@'%' IDENTIFIED BY 'fengj_Test';

授权查询：GRANT select ON fengj_test.* TO 'fengj_test'@'%' IDENTIFIED BY 'fengj_Test';

删除用户：DROP USER 'fengj_test'@'%';

创建数据库：create database wiki default character set utf8mb4 collate utf8mb4_unicode_ci;

使生效：flush privileges;

修改当前用户密码：set password=password('123')

数据库添加软连接后访问权限错误：ubuntu : vim /etc/apparmor.d/usr.sbin.mysqld