linux mysql详细使用 摘自beginning linux programming一书
来源:互联网 发布:战神诀坐骑进阶数据 编辑:程序博客网 时间:2024/06/05 17:20
检测mysl是否启动:
ps -el|grep mysqld
4 S 0 2176 1995 0 80 0 - 554 rt_sig pts/0 00:00:00 mysqld_safe
4 S 104 2532 2176 0 80 0 - 79297 poll_s pts/0 00:00:00 mysqld
mysqld_safe是一个以正确的id启动真正的mysqld进程的工具。
原文:As with a Linux system, it’s a bad idea to use the root account to log in to MySQL unless it’s absolutely necessary, so you should create an everyday user for normal use.
linux系统不适于用root用户登录mysql,所以应当创建一个日常用户。
原文:the root user is allowed to connect from only the local machine as a security measure.
出于安全考虑,root用户仅可从本地机器连接mysql。
一. Grant方法:
原文:You create users and assign them privileges by using the grant command.
使用grant方法创建用户、赋予用户权限。
1. Create a local login for rick
示例:grant all on *.* to rick@localhost identified by '123456';
2. create a login from anywhere on the class C subnet of 192.168.0. Notice that you must use
single quotes to protect the IP range, and use a mask /255.255.255.0 to identify the range of
IP addresses that are allowed
示例:GRANT ALL ON *.* TO rick@‘192.168.0.0/255.255.255.0’ IDENTIFIED BY ‘secretpassword’;
3. Finally, create a login so that rick can log on from any machine in the wiley.com domain
(again notice the single quotes)
示例:GRANT ALL ON *.* TO rick@‘%.wiley.com’ IDENTIFIED BY ‘secretpassword’;
- linux mysql详细使用 摘自beginning linux programming一书
- 《Beginning Linux Programming》读书笔记(一)
- Beginning Linux Programming
- 《beginning linux programming 4th edition》中文翻译(一)
- Beginning Linux Programming 笔记(一) 新的开始
- Beginning Linux Programming, Third Edition
- Beginning Linux Programming Third Edition
- Beginning Linux Programming chapter 3
- Beginning Linux Programming chapter 4
- Beginning Linux Programming chapter 7
- Beginning Linux Programming chapter 11
- Beginning Linux Programming chapter 13
- Beginning Linux Programming Third Edition
- 【读书笔记0103】Beginning linux programming-shell programming
- Linux Beginning (一)
- Beginning Linux Programming, 3rd Edition
- 《Beginning Linux Programming》读书笔记(二)
- main程序参数(Beginning Linux Programming)
- Restful POST请求提交json或www-form-urlencoded数据格式的选择
- 关于extjs中form中嵌套iframe中含form的提交问题
- 不应该在where子句中使用聚合函数
- ExtJs中如何灵活使用Iframe!
- gem5如何运行spec2006
- linux mysql详细使用 摘自beginning linux programming一书
- FBI树
- extjs里面的函数传中文
- LoadRunner中使用strtok函数分割字符串
- 百度地图API 新手环境搭建成功,这里列出一个表。
- 俄罗斯方块源码
- Oracle 10g和Oracle 9i中merge into的区别
- Web.Config文件中数据库连接配置
- ubuntu12.04 U盘启动制作