Mysql创建用户赋权操作及修改密码
来源:互联网 发布:dota2怎么看数据 编辑:程序博客网 时间:2024/06/05 05:56
创建用户:
mysql> create user 'username'@'ipaddress' identified by 'password';#注:如果ipaddress为'%',代表任何地址都可以用新建的用户名连接mysql> create user 'myroot'@'123.123.12.123' identified by 'mypass';mysql> create user 'myroot'@'%' identified by 'mypass';mysql> create user 'myroot'@'%' identified by '';mysql> create user 'myroot'@'%';
创建之后,查询用户权限:
mysql> use mysql;mysql> show grants for myroot@123.123.12.123;+------------------------------------------------+| Grants for 'myroot'@'123.123.12.123' |+------------------------------------------------+| GRANT USAGE ON *.* TO 'myroot'@'123.123.12.123' |+------------------------------------------------+
授权:
给用户myroot赋予所有数据库的所有权限
mysql> grant all privileges on *.* to 'myroot'@'123.123.12.123' identified by 'mypass' with grant option;
给用户myroot赋予数据库db_school的所有权限
mysql> grant all privileges on db_school.* to 'myroot'@'123.123.12.123' identified by 'mypass' with grant option;
指定IP段用户赋权
mysql> grant all privileges on db_school.* to 'myroot'@'123.123.%' identified by 'mypass' with grant option;
给用户myroot赋予数据库db_school中表stu1的查询和新增的权限
mysql> grant select,update on db_school.stu1 to 'myroot'@'123.123.12.123' identified by 'mypass' with grant option;
解除权限:
mysql> revoke select on db_school.stu1 from 'myroot'@'123.123.12.123' with grant option;mysql> show grants for 'myroot'@'123.123.12.123';+----------------------------------------------------------------------------------+| Grants for 'myroot'@'123.123.12.123' |+----------------------------------------------------------------------------------+| GRANT USAGE ON *.* TO 'myroot'@'123.123.12.123' || GRANT UPDATE ON 'db_school'.'stu1' TO 'myroot'@'123.123.12.123' WITH GRANT OPTION|+----------------------------------------------------------------------------------+
删除用户
mysql> drop user 'myroot'@'123.123.12.123';
修改密码
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &mysqluse mysql;update user set authentication_string=password('root123') where user='root';flush privileges;exit;service mysqld restart;
0 0
- Mysql创建用户赋权操作及修改密码
- Oracle操作(解锁用户,修改密码,无密码登录,创建表空间,赋权)
- ubuntu创建mysql用户、赋权限、修改密码
- MySql用户操作:创建、删除、赋权
- mysql 创建用户及赋权
- mysql用户创建及赋权
- Linux下Mysql数据库修改root密码、新增用户和赋权等操作
- mysql创建用户 赋权
- MySQL创建用户及赋权限
- mysql创建用户及赋权限
- Mysql 关于创建用户,赋权限、改密码
- Oracle:添加用户,赋权,修改密码,解锁,删除用户
- Oracle:添加用户,赋权,修改密码,解锁,删除用户
- mysql 创建 用户 并赋权 远程登陆
- mysql创建用户和赋权
- mysql创建用户以及赋权
- oracle创建用户及赋权
- Oracle用户创建及赋权
- QuickHit
- 数据结构==》排序之归并排序
- POJ 2392 Space Elevator 已被翻译
- 关于栈与递归求解迷宫与迷宫最短路径问题
- 开源软件之七宗罪以及背后的阴谋
- Mysql创建用户赋权操作及修改密码
- 【Window】获取电脑连接的网络信息
- Hibernate 命名查询、本地SQL、自定义SQL
- NOIP2016提高组首赛回顾总结
- Hibernate三级缓存
- 数据结构===》排序之基数排序
- 道者,人之所韬,使万物不知其所由
- SPWM
- ios规范与技巧