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

Sat, 25 Oct 2014 08:54:33 -0700 

On Sat, 25 Oct 2014 19:20:35 +0400
[email protected] wrote: 

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

снова копи-паста с лысяры?

в mysql есть %, вместо *

> Есть 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]
> 



--
wbr, tiger

Ответить