#授权username用户获得dbname数据库的所有权限,并且仅限在本地链接。
grant
all
privileges
on
dbname.*
to
username@localhost identified
by
'password'
;