create user ‘sopr‘@‘%‘ identified by ‘sopr‘;
GRANT ALL PRIVILEGES ON *.* TO ‘sopr‘@‘%‘ IDENTIFIED BY ‘sopr‘ WITH GRANT OPTION;
flush privileges;
重启一下：sudo service mysqld restart
mysql创建和授权
原文：http://www.cnblogs.com/doublehappyi/p/5135791.html
