집 >데이터 베이스 >MySQL 튜토리얼 >mysql创建修改删除用户_MySQL

mysql创建修改删除用户_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB원래의: 2016-06-01 13:32:061192검색

bitsCN.com

mysql创建修改删除用户

创建create user &#39;test1&#39;@&#39;localhost/127.0.0.1&#39; identified by &#39;123&#39; 本机权限create user &#39;test1&#39;@&#39;%&#39; identified by &#39;123&#39; 所有权限删除drop user &#39;user&#39;@&#39;host&#39;撤销用户权限revoke all on *.* from &#39;test&#39;@&#39;localhost&#39;;

更改用户名rename user &#39;test&#39;@&#39;localhost&#39; to &#39;test1&#39;@&#39;%&#39;;增加权限GRANT ALL PRIVILEGES ON app.* TO webuser@"%";grant select,update(field1,field2) on dbname.tablename to &#39;test1&#39;@&#39;%&#39;grantselecton testdb.*to common_user@&#39;%&#39;

bitsCN.com

성명：

이전 기사：MYSQL5.5表分区问题_MySQL다음 기사：mysql xtrabackup增量备份_MySQL

mysql创建修改删除用户_MySQL

관련 기사