[freebsd] Не пускает в MySQL (разница в формате логина)

Sat, 25 Oct 2014 08:21:02 -0700 

Добрый день, еще раз.

Есть MySQL

mysql -u sys_auth_blah -p пускает,
mysql -u sys_auth_blah@localhost -p не пускает

В чем разница?


mysql> select user, host, password from mysql.user;    (вывод порезан)
+------------------+-----------+-------------------------------------------+
| user             | host      | password                                  |
+------------------+-----------+-------------------------------------------+
| sys_auth_blah   | *         | *015571C4B912F7F883CF48A24C3AD6DC4чччч |
| sys_auth_blah   | localhost | *015571C4B912F7F883CF48A24C3AD6DC4чччч |
+------------------+-----------+-------------------------------------------+
20 rows in set (0.01 sec)


mysql> show grants for sys_auth_blah@localhost;
+--------------------------------------------------------------------------------------------------------------------------------+
| Grants for sys_auth_blah@localhost                                            
                                                |
+--------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'sys_auth_blah'@'localhost' IDENTIFIED BY 
PASSWORD '*015571C4B912F7F883CF48A24C3AD6DC4x' |
+--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show grants for sys_auth_blah@'*';
+------------------------------------------------------------------------------------------------------------------------+
| Grants for sys_auth_blah@*                                                    
                                        |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'sys_auth_blah'@'*' IDENTIFIED BY PASSWORD 
'*015571C4B912F7F883CF48A24C3AD6DC4' |
+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)




С уважением, Виталий Михно

Vitaly A. Mikhno


System Administration
Technical Support

phone: +7-911-935-98-56 (cellular)

ICQ: 175559847
Jabber: [email protected]

skype://Vitaly9856

primary e-mail: [email protected]
secondary e-mail: [email protected]

Ответить