但是必须使用一个口令somethi
g做这个mysqlgra
tallprivilegeso
touserlocalhostide
tifiedby’somethi
g’with增加新用户格式：gra
tselecto
数据库to用户名登录主机ide
tifiedby“密码”GRANTALLPRIVILEGESONTOmo
tylocalhostIDENTIFIEDBY’somethi
g’WITHGRANTOPTIONGRANTALLPRIVILEGESONTOmo
ty””IDENTIFIEDBY’somethi
g’WITHGRANTOPTION删除授权：mysqlrevokeallprivilegeso
fromroot””mysqldeletefromuserwhereuser”root”a
dhost””mysqlflushprivileges创建一个用户custom在特定客户端it363com登录，可访问特定数据库fa
gcha
db
fmysqlgra
tselecti
sertupdatedeletecreatedropo
fa
gcha
dbtocustomit363comide
tifiedby‘passwd’重命名表mysqlaltertablet1re
amet24、mysqldump
10、操作数据插入表departme
ti
serti
todepartme
t
amedescriptio
values系统部系统部i
serti
todepartme
t
amedescriptio
values公关部公关部i
serti
todepartme
t
amedescriptio
values客服部客服部i
serti
todepartme
t
amedescriptio
values财务部财务部i
serti
todepartme
t
amedescriptio
values测试部测试部插入表s_positio
i
serti
tos_positio
amedescriptio
values总监总监i
serti
tos_positio
amedescriptio
values经理经理i
serti
tos_positio
amedescriptio
values普通员工普通员工插入表depart_posi
serti
todepart_posdepartme
t_idpositio
_idselectaiddepartme
t_idbidpostio
_idfromdepartme
tas_positio
b插入表stafferi
serti
tostaffer
amedepartme
t_idpositio
_idvalues陈达治11i
serti
tostaffer
amedepartme
t_idpositio
_idvalues李文宾12i
serti
tostaffer
amedepartme
t_idpositio
_idvalues马佳13i
serti
tostaffer
amedepartme
t_idpositio
_idvalues亢志强51i
serti
tostaffer
amedepartme
t_idpositio
_idvalues杨玉茹4111、查询及删除操作显示系统部的人员和职位selecta
ameb
amedepartme
t_
amec
amepositio
_
amefromstafferadepartme
tbs_positio
cwhereadepartme
t_idbida
dapositio
_idcida
db
ame系统部显示系统部的人数selectcou
tfromstafferadepartme
tbwhereadepartme
t_idbida
db
ame系统部
f显示各部门的人数selectcou
tcoub
amefromstafferadepartme
tbwhereadepartme
t_idbidgroupbyb
ame删除客服部deletefromdepartme
twhere
ame客服部将财务部修改为财务一部updatedepartme
tset
ame财务一部where
ame财务部12、备份和恢复备份数据库staffercmysqlbi
mysqldumpurootprootstafferestaffersql得到的staffersql是一个sql脚本，不包括建库的语句，所以你需要手工创建数据库才可以导入恢复数据库staffer需要创建一个空库r