计算机知识分享网

【mysql】mysql创建用户并授权某个数据库

想利用 service mysql start 启动mysql数据库,但是发现出现错误:
# 创建用户davidzheng,并设置密码woshimimapassword
# 授权数据库db_test给用户davidzheng
create user 'davidzheng'@'%' identified by 'woshimimapassword';
grant all privileges on db_test.* to 'davidzheng'@'%';
flush privileges;

#Mysql