На этот раз нет, с mysql.com, я их перепутал (почему-то решил, что *any, a %-any except localhost Спасибо.
SVD> снова копи-паста с лысяры? SVD> в 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] >> SVD> -- SVD> wbr, tiger С уважением, Виталий Михно 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]
