Just started with mysql. I login with root and follow the online reference to create a new user:

mysql> CREATE USER 'abc'@'%' IDENTIFIED BY '111111';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'abc'@'%' WITH GRANT OPTION;

then I quit and tried to login with the new user:

mysql --user=abc --password=111111 mysql

But got an error message:

Access denied for user 'abc'@'localhost' (using password: YES)

Did I missed something?

Edit
Report