<![CDATA[静怡家园]]> http://www.zhanghaijun.com/index.php zh-cn http://www.zhanghaijun.com/post// <![CDATA[mysql 5.6 private_key.pem public_key.pem file not found]]> 碟舞飞扬 <webmaster@zhanghaijun.com> Thu, 14 Aug 2014 09:12:21 +0000 http://www.zhanghaijun.com/post// 2014-08-14 15:28:45 15388 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-14 15:28:45 15388 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-14 15:28:45 15388 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-14 15:28:45 15388 [Note] InnoDB: Memory barrier is not used
2014-08-14 15:28:45 15388 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-14 15:28:45 15388 [Note] InnoDB: Using Linux native AIO
2014-08-14 15:28:45 15388 [Note] InnoDB: Using CPU crc32 instructions
2014-08-14 15:28:45 15388 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2014-08-14 15:28:45 15388 [Note] InnoDB: Completed initialization of buffer pool
2014-08-14 15:28:45 15388 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-14 15:28:45 15388 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-14 15:28:45 15388 [Note] InnoDB: Waiting for purge to start
2014-08-14 15:28:45 15388 [Note] InnoDB: 5.6.20 started; log sequence number 1661278
2014-08-14 15:28:45 15388 [Note] RSA private key file not found: /home/mysql2015/data//private_key.pem. Some authentication plugins will not work.
2014-08-14 15:28:45 15388 [Note] RSA public key file not found: /home/mysql2015/data//public_key.pem. Some authentication plugins will not work.
2014-08-14 15:28:45 15388 [Note] Server hostname (bind-address): '0.0.0.0'; port: 2015
2014-08-14 15:28:45 15388 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2014-08-14 15:28:45 15388 [Note] Server socket created on IP: '0.0.0.0'.
2014-08-14 15:28:46 15388 [Note] Event Scheduler: Loaded 0 events
2014-08-14 15:28:46 15388 [Note] /usr/local/webserver/mysql2015/bin/mysqld: ready for connections.
Version: '5.6.20-log'  socket: '/tmp/mysql2015.sock'  port: 2015  Source distribution
处理了一个MySQL Plugin 'FEDERATED' is disabled 的问题，发现日志里还有一个RSA private key file not found的问题，sha256_password这个插件是MySQL5.6内置的，支持更为强大的用户密码加密方式。

解决方法：

openssl genrsa -out mykey.pem 1024
openssl rsa -in mykey.pem -pubout > mykey.pub


chmod 400 mykey.pem
chmod 444 mykey.pub
chown mysql:mysql mykey.pem
chown mysql:mysql mykey.pub


vi my.cnf 在[mysqld]下面加以下两行：
sha256_password_private_key_path=/home/mysql2015/mykey.pem
sha256_password_public_key_path=/home/mysql2015/mykey.pub
保存之后，重启MYSQL服务，日志不再有以下错误了
RSA private key file not found: /home/mysql2015/data//private_key.pem. Some authentication plugins will not work.
RSA public key file not found: /home/mysql2015/data//public_key.pem. Some authentication plugins will not work.
Tags - , , ]]> http://www.zhanghaijun.com/post//#blogcomment <![CDATA[[评论] mysql 5.6 private_key.pem public_key.pem file not found]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://www.zhanghaijun.com/post//#blogcomment