CODEWITHSUNDEEP
mysqlpasswordschef-infra
ironsand
ironsand

Reputation: 15181

How to create mysql user from unix user by using shadow hash

Is there a way to create a Mysql user from existing unix user without asking plain password. Instead of it by using shadow hash.

It would be great if you know how to do it with chef, but it also very helpful if you tell me how to do it directly by mysql command.

Upvotes: 1

Views: 172

Answers (1)

StephenKing
StephenKing

Reputation: 37630

To my knowledge there is no way and it is by far not Chef's "fault".

MySQL uses an own PASSWORD() method to hash passwords. There is AFAIK no support for the libcrypt style hashed passwords. More information can be found here, but I didn't find anything related to other hashing methods.

Upvotes: 1

Related Questions