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

This article mainly explains "how to solve the problem of mysql error reporting RSA private key file not found". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "mysql error report RSA private key file not found how to solve it"!

Install mysql 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. Solutions are 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) so far I believe that you have a deeper understanding of "mysql error RSA private key file not found how to solve", might as well come to the actual operation! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.