mysql增加新用户无法登陆解决方法

为某个服务增加对应的用户后，发现
无法使用新增的用户登陆mysql。我增加用户的方法如下：
 grant replication client on *.* to 'check'@'%' identified by 'tcs6688';
flush privileges
mysql -ucheck -ptcs6688 -S /data/3306/mysql.sock
ERROR 1045 (28000): Access denied for user 'check'@'localhost' (using password: YES)
			
				
			
解决方法： 
增加普通用户后，执行： 
mysql> use mysql
mysql> select host,user,password from user;
+--------------------+--------+-------------------------------------------+
| host               | user   | password                                  |
+--------------------+--------+-------------------------------------------+
| localhost          | root   | *D33EDEA6146A5F30C4D2F417891D199C00099B41 |
| oldboy.localdomain | root   |                                           |
| 127.0.0.1          | root   |                                           |
| ::1                | root   |                                           |
| localhost          |        |                                           |
| oldboy.localdomain |        |                                           |
| 192.168.179.%      | rep    | *4F567C322C9F749E6278E501EC4F3E80EBF7F064 |
| 192.168.%.%        | root   | *6B8CCC83799A26CD19D7AD9AEEADBCD30D8A8664 |
| %mysql.com         | root   | *6B8CCC83799A26CD19D7AD9AEEADBCD30D8A8664 |
| 192.168.179.%      | amoeba | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |
| %                  | check  | *7FBCCEAD989C98AE47906593F06065430711C06C |
+--------------------+--------+-------------------------------------------+
11 rows in set (0.07 sec)
			
				
			

mysql> 
delete from user where user=''; 
mysql> flush privileges; 
意思是删除匿名用户。
mysql -ucheck -ptcs6688 -S /data/3306/mysql.sock 
			
				再次登陆OK

另外一种情况是新增的授权用户，直接回去就可以登录
mysql>  select host,user,password from user;
| localhost          |        |                                           |
mysql> drop user ""@localhost;
				
					因为localhost后面对应的密码是空，当然可以登录，除非给localhost设置密码