版本:5.7.18
错误信息:
2017-05-31T14:14:07.001316Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-05-31T14:14:07.001451Z 0 [ERROR] SSL error: Unable to get private key from 'server-key.pem'
2017-05-31T14:14:07.001463Z 0 [Warning] Failed to set up SSL because of the following SSL library error: Unable to get private key
查看文件权限:
[mysql@izwz9gxsbwybwg9n5xdi47z data]$ ls -al
total 98372
drwxr-xr-x 5 mysql mysql 4096 May 31 22:14 .
drwxr-xr-x 14 mysql mysql 4096 May 31 22:00 ..
-rw-r----- 1 mysql mysql 56 May 31 22:06 auto.cnf
-rw------- 1 mysql mysql 1675 May 31 22:08 ca-key.pem
-rw-r--r-- 1 mysql mysql 1074 May 31 22:08 ca.pem
-rw-r--r-- 1 mysql mysql 1078 May 31 22:08 client-cert.pem
-rw------- 1 mysql mysql 1675 May 31 22:08 client-key.pem
-rw-r----- 1 mysql mysql 50331648 May 31 22:06 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 May 31 22:06 ib_logfile1
-rw-r----- 1 mysql mysql 6 May 31 22:14 izwz9gxsbwybwg9n5xdi47z.pid
drwxr-x--- 2 mysql mysql 4096 May 31 22:06 mysql
drwxr-x--- 2 mysql mysql 4096 May 31 22:06 performance_schema
-rw------- 1 mysql mysql 1675 May 31 22:08 private_key.pem
-rw-r--r-- 1 mysql mysql 451 May 31 22:08 public_key.pem
-rw-r--r-- 1 mysql mysql 1078 May 31 22:08 server-cert.pem
-rw------- 1 mysql mysql 1679 May 31 22:08 server-key.pem
drwxr-x--- 2 mysql mysql 12288 May 31 22:06 sys
加上R权限
[mysql@izwz9gxsbwybwg9n5xdi47z data]$ chmod 644 server-key.pem
[mysql@izwz9gxsbwybwg9n5xdi47z data]$ ls -al
total 98372
drwxr-xr-x 5 mysql mysql 4096 May 31 22:14 .
drwxr-xr-x 14 mysql mysql 4096 May 31 22:00 ..
-rw-r----- 1 mysql mysql 56 May 31 22:06 auto.cnf
-rw------- 1 mysql mysql 1675 May 31 22:08 ca-key.pem
-rw-r--r-- 1 mysql mysql 1074 May 31 22:08 ca.pem
-rw-r--r-- 1 mysql mysql 1078 May 31 22:08 client-cert.pem
-rw------- 1 mysql mysql 1675 May 31 22:08 client-key.pem
-rw-r----- 1 mysql mysql 50331648 May 31 22:06 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 May 31 22:06 ib_logfile1
-rw-r----- 1 mysql mysql 6 May 31 22:14 izwz9gxsbwybwg9n5xdi47z.pid
drwxr-x--- 2 mysql mysql 4096 May 31 22:06 mysql
drwxr-x--- 2 mysql mysql 4096 May 31 22:06 performance_schema
-rw------- 1 mysql mysql 1675 May 31 22:08 private_key.pem
-rw-r--r-- 1 mysql mysql 451 May 31 22:08 public_key.pem
-rw-r--r-- 1 mysql mysql 1078 May 31 22:08 server-cert.pem
-rw-r--r-- 1 mysql mysql 1679 May 31 22:08 server-key.pem
drwxr-x--- 2 mysql mysql 12288 May 31 22:06 sys
重启后错误再没有出现。
阅读(3218) | 评论(0) | 转发(0) |