mysql RSA private key file not found
安裝mysql報錯
[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.
解決方法如下：
1.檢查是否安裝openssl
$rpm -qa openssl openssl-1.0.0-20.el6_2.5.x86_64
2.利用openssl生成公有和私有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 key
3.修改key的許可權
$ chmod 400 mykey.pem$ chmod 444 mykey.pubchown mysql:mysql mykey.pemchown mysql:mysql mykey.pub
4.把公私有key的路徑加入到my.cnf中
sha256_password_private_key_path=mykey.pem sha256_password_public_key_path=mykey.pub如果key放在datadir目錄下，直接寫key名即可。否則要指定key的全路徑
5.重啟mysql
SHOW STATUS檢視Rsa_public_key狀態，如果不為空，則OK.
mysql> SHOW STATUS LIKE 'Rsa_public_key'\G*************************** 1. row ***************************Variable_name: Rsa_public_key Value: -----BEGIN PUBLIC KEY-----MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEALeNX9dY4EMlaDHCIYPBvFNN NJG2f6dtsyV/IG94TFsKtx/Xobiiz9ihBZSWvUhlfz6aVy9TbN68YEn58G5oOS3o sxKZQvDF9XvjN0thDPwCgfIwTZgatqmrV/qGewCxQpQ03WHPx+GXQmM9iFSfM84F pZ8QtiI3m+fIUaOd/QIDAQAB -----END PUBLIC KEY----- 1 row in set (0.00 sec)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31559985/viewspace-2652899/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MySQL server PID file could not be found!MySqlServer
- MysqL錯誤之_ERROR! MySQL server PID file could not be found!MySqlErrorServer
- MySQL 5.7.17 安裝報錯SSL error: Unable to get private key fromMySqlError
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- Error 15: File not found for RedhatErrorRedhat
- ORA-08102: index key not found, obj# 56687, file 54, block 176049 (2)IndexOBJBloC
- file not found WFMLRSVCApp.earAPP
- SSH auth method: private key 的解決方案
- Newline required at end of file but not foundUI
- Porting .Net RSA xml keys to JavaXMLJava
- More than one file was found with OS independent path
- Android：Unexpected lock protocol found in lock file. Expected 3, found 0.AndroidProtocol
- 如何獲取SSL證書private key私鑰檔案
- GitHub/GitLab配置SSH Key，以及RSA入門GithubGitlab
- Generate BKS File（ Bouncy Castle KeyStore）AST
- MySQL 5.6複製報錯Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;MySqlError
- 【Vagrant】啟動安裝Homestead卡在 SSH auth method: private key
- MySQL執行語句報Incorrect key file for table '/tmp/#sql_.MYI'; try to repair itMySqlAI
- GPG key retrieval failed: [Errno 14] HTTP Error 404: Not FoundAIHTTPError
- keycloak~jwks-rsa中使用的設計模式設計模式
- mac mysql: command not foundMacMySql
- 【原創】淺析密碼學在網際網路支付中的應用|RSA,Hash,AES,DES,3DES,SHA1,SHA256,MD5,SSL,Private Key,Public Key密碼學3D
- yum-GPG key retrieval failed: No such file or directoryAI
- mysql drop keyMySql
- 'libxml/HTMLparser.h' file not found in ASIHTTPRequest 解決方法XMLHTMLHTTP
- no- valid devices were found on which to create new file systemsdev
- go tool compile 報錯 could not import sync (file not found)GoCompileImport
- Mac -bash: mysql: command not foundMacMySql
- mysql中key 、primary key 、unique key 與index區別MySqlIndex
- React Native 報錯 'config.h' file not foundReact Native
- Api32 keygen: learn how to use RSA (4千字)API
- Mysql Key Buffer SizeMySql
- MySQL KEY分割槽MySql
- ssh 遠端登入報錯：Unable to negotiate with IP port 22: no matching host key type found. Their offer: ssh-rsa,ssh-dss 解決辦法Go
- centos 7 -bash: mysql: command not foundCentOSMySql
- MyIsam 表 “ Incorrect key file for table 't_ '; try to repair it”AI
- mac php8安裝swoole 'pcre2.h' file not foundMacPHP
- 【ASM】Oracle RAC css啟動報錯"Duplicate voting file found"ASMOracleCSS