第1个回答 推荐于2016-08-17
CREATE DATABASE test2 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pwd' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION;
FLUSH PRIVILEGES;本回答被提问者和网友采纳