New mysql User cannot log on locally _ MySQL

New mysql User cannot log on to bitsCN.com locally

New mysql User cannot log on locally

Mysql is used. because the root permission is too high, appadmin is created for a new user. The permission is only for the database to be used. The creation statement is as follows: grant select, insert, update, delete on test. * to appadmin @ "%" identified by "password"; where @ "%" can be logged on at any address.

After the user is created, go to mysql. user to view the user. However, if you use mysql-u appadmin-ppassword to log on, the system prompts "ERROR 1045 (28000): Access denied for user 'appadmin' @ 'localhost' (using password: YES)" cannot be logged on)

Some of them said, "mysql. there are other records in the user table, which are most likely to have a ''@ localhost record, that is, the username is empty, and the host field is the localhost record." Affected. Check the table.

mysql> select host,user,password from mysql.user; +-----------+------------------+-------------------------------------------+ | host      | user             | password                                  | +-----------+------------------+-------------------------------------------+ | localhost | root             | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | mza       | root             | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | 127.0.0.1 | root             | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | localhost |                  |                                           | | mza       |                  |                                           | | localhost | debian-sys-maint | *19DF6BF8310D46D681AE072AB73ECEC99C018C19 | | %         | appadmin         | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | +-----------+------------------+-------------------------------------------+ 7 rows in set (0.00 sec) 

However, users who are empty (anonymous) cannot log on after deletion. (Probably because mysql was not restarted) so I had to be patient and read the mysql Reference Manual. We found that the added users have the following words:

The two accounts have the same username and password "monty" and "some_pass. Both accounts are superuser accounts and have full permissions to do anything. An account ('Monty '@ 'localhost') is only used for connection from the local machine. Another account ('Monty '@' % ') can be used to connect from other hosts. Note that the two accounts of monty must be able to connect to monty from any host. There is no localhost account. when monty is connected from the local machine, the anonymous user account of localhost created by mysql_install_db takes the lead. As a result, monty is considered an anonymous user. The reason is that the Host column value of the anonymous user account is more specific than that of the 'Monty '@' % 'account, so that it is ranked first in the sorting order of the user table.

This statement is clear, so grant select, insert, update, delete on test. * to appadmin @ "localhost" identified by "password ";

Log on to the Apsara stack console with appadmin.

BitsCN.com