mysql创建用户和密码出现错误怎么办

mysql># service mysqld stop

mysql># mysqld_safe --skip-grant-table

mysql -u root mysql

delete from user where USER='';

FLUSH PRIVILEGES;

mysql -u root -p

mysql> create user 'username'@'%' identified by 'password';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to 'username'@'%';

Query OK, 0 rows affected (0.00 sec)