ADADADADAD

MySQL数据库权限操作[ mysql数据库 ]

mysql数据库时间：2024-12-25 09:56:02

作者：文/会员上传

如何提高mysql查询效率

简介：

操作对象：线上和测试所有MySQL Plus数据库创建用户：create user 'testname'@'%' identified by '123456';查看testname用户的权限show grants for testname;testname用户授权：G

以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。

操作对象：

线上和测试所有MySQL Plus数据库

创建用户：

create user 'testname'@'%' identified by '123456';

查看testname用户的权限

show grants for testname;

testname用户授权：

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX,ALTER,SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON *.* TO 'testnam'@'%';

#创建用户并授权

GRANT ALL PRIVILEGES ON *.* TO 'testname'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;

testname用户原有权限：

SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX,ALTER,SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER

查看用户的授权权限：

select * from mysql.user where User='testname' and Host='%'\G;

修改用户的授权权限：

update mysql.user set Grant_priv='Y' where User='testname' and Host='%';flush privileges;

回收权限：

CREATE,DROP,ALTERrevoke CREATE,DROP,ALTER on *.* from testname@'%';

线上授权testname1：

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON *.* TO 'testname1'@'%';

mysqladmin -u testname1 -h2.1.1.1 password C123456 "c123456"

修改密码：

set password = password 'C123456';

MySQL数据库权限操作.docx

将本文的Word文档下载到电脑

下载

热门标签: 数据库mysql权限操作

精品

申请https需要什么条件

MySQL数据库权限操作[ mysql数据库 ]

MySQL数据库权限操作.docx

精品

热门推荐

大家都在看