數(shù)據(jù)庫權(quán)限的賦值使用grant命令，以下為創(chuàng)建一個數(shù)據(jù)庫、賦值權(quán)限、設(shè)置數(shù)據(jù)庫用戶名和密碼；
mysql -u root -p
create database mysqltest;
grant Select,Insert,Update privileges on mysqltest.* to 'mysqltest'@'localhost' identified by 'mysqltestmima123';
flush privileges;
quit

創(chuàng)建數(shù)據(jù)庫mysqltest,數(shù)據(jù)庫用戶名mysqltest,數(shù)據(jù)庫密碼mysqltestmima123
數(shù)據(jù)庫相應(yīng)的權(quán)限是：Select,Insert,Update
查詢，寫入，更新