12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-11-29 10:09:15
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
mysql5.7增加用户的方法：首先登录mysql；然后执行【CREATE USER 'test'@'localhost' IDENTIFIED BY '1234';】语句即可增加用户。增加用户举例：创建tes
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
mysql5.7增加用户的方法：首先登录mysql；然后执行【CREATE USER 'test'@'localhost' IDENTIFIED BY '1234';】语句即可增加用户。
增加用户
举例：创建test用户，密码是1234
MySQL -u root -p CREATE USER 'test'@'localhost'IDENTIFIED BY '1234'; #本地登录 CREATE USER 'test'@'%'IDENTIFIED BY '1234'; #远程登录 quit mysql -u test -p #测试是否创建成功
删除用户
mysql -u root -p Delete FROM mysql.user Where User=”test” and Host=”localhost”; flush privileges; drop database testDB;
删除账户及权限：
drop user 用户名@’%’; drop user 用户名@ localhost;
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19