Techyou labs
文章RSS
评论RSS
登录
真正的爱应该超越生命的长度,心灵的宽度,灵魂的深度
搜索
关于作者
文章分类
Default
Linux/Unix
Database
Cloud
Networking
Security
Programming
最新文章
带你重走 TiDB TPS 提升 1000 倍的性能优化之旅
Unicode 中的 BIDI 双向性算法[转]
在linux中设置优先使用ipv4,而不是ipv6
linux下WPS高分辨率下因字体缩放导致字体发虚的问题
ssh-rsa not in pubkeyacceptedalgorithms问题解答及处理办法 Permission denied (publickey)
在 Ubuntu 22.04 中使用 PipeWire 替换 PulseAudio
MYSQL简单监控指标
deepin-wine6-stable下TIM悄悄崩溃问题
openwrt 设置ipv6地址分配
Redis 实战篇:巧用数据类型实现亿级数据统计
最新评论
renothing: 备注:路由器端优先设置ipv4并不影响客户端的ip...
renothing: 二次反向代理跟你应用程序得处理时间有关系吧?尤其是...
二次反向代理性能很差,怎么优化的?: 我也用nginx 做了个二次反向代理,但是并发连3...
hostyep: 交换链接么?目前每天保持30个左右对口IP,每月都...
yzhkpli: error while loading share...
美肤宝: 感谢分享。。。
lq: 嗯 喜欢弄得点单点
按月归档
March 2023
December 2022
November 2022
September 2022
August 2022
March 2022
January 2022
November 2021
October 2021
September 2021
August 2021
July 2021
June 2021
February 2021
September 2020
May 2020
September 2019
August 2019
July 2019
June 2019
May 2019
January 2019
December 2018
November 2018
October 2018
September 2018
August 2018
July 2018
June 2018
April 2018
March 2018
December 2017
October 2017
September 2017
August 2017
April 2017
March 2017
February 2017
August 2016
July 2015
November 2014
September 2014
August 2014
July 2014
June 2014
July 2013
April 2013
September 2012
July 2012
May 2012
April 2012
February 2012
January 2012
December 2011
November 2011
October 2011
September 2011
August 2011
December 2010
November 2010
October 2010
September 2010
August 2010
July 2010
June 2010
May 2010
April 2010
March 2010
February 2010
January 2010
December 2009
November 2009
October 2009
September 2009
August 2009
June 2009
May 2009
April 2009
March 2009
February 2009
December 2008
November 2008
September 2008
August 2008
July 2008
June 2008
常用标签
Mysql
nginx
mysql优化
linux
debian
Powered by
Typecho)))
Optimized by
EAimTY
mysql 基础管理学习笔记
March 24, 2009
给 root 用户设置密码: ``` mysqladmin -u root password
``` 修改 root 用户的密码: ``` mysqladmin -u root password
Enter password:
```` root@localhost 和 root@127.0.0.1 的区别: 前者是通过 sock 连接,而后者是通过 TCP 连接。 查看数据库中的用户: ``` select host, user from mysql.user; ``` 查看当前用户权限: ``` show grants; ``` 查看指定用户权限: ``` show grants for
@
; ``` 普通用户权限(查询、插入、更新、删除 表数据): ``` grant select, insert, update, delete on test.* to test@'%'; ``` 开发人员权限: 创建、修改、删除 表的权限: ``` grant create, alter, drop on test.* to dev@'192.168.0.%'; ``` 外键: references 临时表: create temporary tables 索引: index 创建视图: create view 查看视图源代码: show view 创建存储过程: create routine 修改存储过程: alter routine 函数: execute 普通数据库管理员权限: ``` grant all on test.* to testdba@'localhost'; ``` 顶级权限: ``` grant all on *.* to dba@'localhost'; ``` 顶级权限加授权权限: ``` grant all on *.* to root@'localhost' with grant option; ``` 撤销权限: ``` revoke
on
.
from '
'@'
'; ``` 撤销所有权限: ``` revoke all on *.* from dba@'localhost'; ``` “授权”权限: ``` grant all on test.* to testdba@localhost with grant option; revoke grant option on test.* from testdba@localhost; ``` 添加用户: ``` grant all on
.
to '
'@'
' identified by '
'; flush privileges; ``` 删除用户: ``` delete from mysql.user where user='
' and host='
'; flush privileges; ``` 更改用户主机: ``` update mysql.user set host='127.0.0.1' where user='test'; ``` 修改用户密码: ``` set password for '
'@'
' = password('
'); ``` 忘记 root 密码重置: 在 my.cnf 文件的 [mysqld] 段添加 skip-grant-tables 后重启,可以免密码登陆,然后重置 root 的密码, ``` update mysql.user set password=password('
') where user='root'; ```
暂无评论
添加新评论
称呼
Email
网站
取消回复
内容
发表评论