21
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?