Shulou(Shulou.com)06/01 Report--

Installation mysql reports an error

[Note] RSA private key file not found: / db/mysql5.6/data//private_key.pem. Some authentication plugins will not work. [Note] RSA public key file not found: / db/mysql5.6/data//public_key.pem. Some authentication plugins will not work.

The solution is as follows:

1. Check if openssl$rpm-qa opensslopenssl-1.0.0-20.el6_2.5.x86_642 is installed. Use openssl to generate public and private key$ openssl genrsa-out mykey.pem 1024Generating RSA private key, 1024 bit long modulus.+.+e is 65537 (0x10001) $openssl rsa-in mykey.pem-pubout-out mykey.pubwriting RSA key3. Modify the permission of key $chmod 400 mykey.pem$ chmod 444 mykey.pubchown mysql:mysql mykey.pemchown mysql:mysql mykey.pub4. Add the public or private key path to the my.cnf sha256_password_private_key_path=mykey.pemsha256_password_public_key_path=mykey.pub. If the key is placed in the datadir directory, write the key name directly. Otherwise, specify the full path of key 5. 0. Restart mysqlSHOW STATUS to check Rsa_public_key status, if not empty Then OK.mysql > SHOW STATUS LIKE 'Rsa_public_key'\ gateway * 1. Row * * Variable_name: Rsa_public_key Value:-BEGIN PUBLIC KEY-MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEALeNX9dY4EMlaDHCIYPBvFNNNJG2f6dtsyV/IG94TFsKtx/Xobiiz9ihBZSWvUhlfz6aVy9TbN68YEn58G5oOS3osxKZQvDF9XvjN0thDPwCgfIwTZgatqmrV/qGewCxQpQ03WHPx+GXQmM9iFSfM84FpZ8QtiI3m+fIUaOd/QIDAQAB-END PUBLIC KEY-- -1 row in set (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.