0基础linux运维教程 mysql数据库服务端

id,name,sub_time

1,第一篇,2015-03-01 11:31:21

2,第二篇,2015-03-11 16:31:21

select id from db1.t1;

select name from db1.t1;

select age from db1.t1;

*.*->mysql.user

grant all on *.* to 'egon'@'%' identified by '123';

db.*->mysql.db

grant all on db1.* to 'tom'@'%' identified by '123';

revoke select on db1.* from 'tom'@'%';

db1.blog->mysql.tables_priv

grant all on db1.blog to 'lili'@'%' identified by '123';

db1.blog->mysql.columns_priv, update权限依赖select权限

grant select (id,sub_time),update (id) on db1.blog to 'xxx'@'%' identified by '123';

all包含grant权限

grant all on *.* to yyy@'%' identified by '123' with grant option;

grant all on *.* to zzz@'%' identified by '123' with max_user_connections 2;

create database db2;

use db2;

create table t1(id int)engine=myisam;

create table t2(id int)engine=myisam;

insert t1 values(1),(2),(3);

insert t2 values(1),(2),(3);

mysql数据库服务端---》innodb存储引擎--》用户态内存空间

操作系统------------》文件系统--------》os cache

计算机硬件----------》硬盘------------》硬盘结构