Shulou(Shulou.com)06/01 Report--

After installing MySQL, root users can set a password to log in, other new users can not log in through a password, can only log in without entering a password, and the authorization for new users is invalid.

-- create a library and user mysql > create database fire; Query OK, 1 row affected (0.00 sec)

Mysql > create user neo identified by 'Mysql#2015'; Query OK, 0 rows affected (0.00 sec)

Mysql > grant select,create,update,delete on fire.* to neo; Query OK, 0 rows affected (0.00 sec)

Mysql > flush privileges; Query OK, 0 rows affected (0.00 sec)

-- using a new user to log in and report an error

[root@localhost data] #. / bin/mysql-u neo-p "Mysql#2015"

ERROR 1045 (28000): Access denied for user 'neo'@'localhost' (using password: YES)

-- but can log in without entering a password

[root@localhost software] #. / bin/mysql-uneo

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 11

Server version: 5.5.48-log production environment

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql > show grants

+-+

| | Grants for @ localhost |

+-+

| | GRANT USAGE ON *. * TO'@ 'localhost' |

+-+

1 row in set (0.00 sec)

Reason for error: after Mysql is installed with source code, there are anonymous users in the database. You can log in to the database without entering a password through any user name.

Mysql > select host,user,password from mysql.user where (user) not in ('root')

+-+

| | host | user | password | |

+-+

| | localhost |

| | localhost.localdomain |

| |% | neo | * CC4C777F1511C297751B78287D6E05345D227819 |

| |% | test | * 443EF031E558E317B19BAD70BDF4E25FA73A89A7 |

+-+

4 rows in set (0.00 sec)

Mysql > select host,user,password from mysql.user where (user) not in ('root','neo','test')

+-- +

| | host | user | password | |

+-- +

| | localhost |

| | localhost.localdomain |

+-- +

2 rows in set (0.00 sec)

Workaround: delete anonymous users.

Mysql > delete from mysql.user where (user) not in ('root','neo','test')

Query OK, 2 rows affected (0.00 sec)

Mysql > flush privileges

Query OK, 0 rows affected (0.00 sec)

The newly created user can then log in to the database normally.

[root@localhost software] #. / bin/mysql-uneo-paired MySQL 2015'

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 1

Server version: 5.5.48-log production environment

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql > show grants

+-+

| | Grants for neo@% |

+-+

| | GRANT USAGE ON *. * TO 'neo'@'%' IDENTIFIED BY PASSWORD |

| | GRANT SELECT, INSERT, DELETE, CREATE ON `fire`.* TO 'neo'@'%' |

+-+

2 rows in set (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.