Today I thought I would grant permissions to use a mysql database.\u00a0 I did the regular thing, but it didn’t work:<\/p>\n
mysql> grant all on *.* to 'user'@'169.254.1.1' identified by 'somesecret';<\/strong>\r\nERROR 1827 (HY000): The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.<\/pre>\nThe reason turned out to be this:<\/p>\n
[root@mysqlserver ~]# grep passwords \/etc\/my.cnf |<\/strong>\r\nold_passwords = 1<\/pre>\nI don’t know how that affects it, but way to grant permissions is to override that setting:<\/p>\n
mysql> set old_passwords=0;<\/strong>\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nmysql> grant all on *.* to 'user'@'169.254.1.1' identified by 'somesecret';<\/strong>\r\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\nAnd viola<\/em> it works!<\/p>\n","protected":false},"excerpt":{"rendered":"
Today I thought I would grant permissions to use a mysql database.\u00a0 I did the regular thing, but it didn’t work: mysql> grant all on *.* to ‘user’@’169.254.1.1’ identified by ‘somesecret’; ERROR 1827 (HY000): The password hash doesn’t have the … Continue reading