mysql名称证书秘钥_mysql通过ssl的方式生成秘钥具体生成步骤

心已赠人 2023-01-11 05:00 349阅读 0赞

mysql通过ssl的方式生成秘钥具体生成步骤

更新时间：2013年06月09日 16:29:09   作者：

在my.cnf末尾端设置ssl 参数， 然后重新启动mysql服务即可，通过openssl生成证书的配置, 在mysql db server上生成秘钥，具体步骤如下，感兴趣的朋友可以参考下哈

\-- mysql ssl 生成秘钥

1 check ssl是否已经开启

mysql> show variables like '%ssl%';

\+---------------+----------+

| Variable\_name | Value |

\+---------------+----------+

| have\_openssl | DISABLED |

| have\_ssl | DISABLED |

| ssl\_ca | |

| ssl\_capath | |

| ssl\_cert | |

| ssl\_cipher | |

| ssl\_crl | |

| ssl\_crlpath | |

| ssl\_key | |

\+---------------+----------+

9 rows in set (0.00 sec)

2 没有开启,所以打开

在my.cnf末尾端设置ssl 参数， 然后重新启动mysql服务即可

mysql> show variables like '%ssl%';

\+---------------+-------+

| Variable\_name | Value |

\+---------------+-------+

| have\_openssl | YES |

| have\_ssl | YES |

| ssl\_ca | |

| ssl\_capath | |

| ssl\_cert | |

| ssl\_cipher | |

| ssl\_crl | |

| ssl\_crlpath | |

| ssl\_key | |

\+---------------+-------+

9 rows in set (0.00 sec)

3 通过openssl生成证书的配置, 在mysql db server上生成秘钥

mkdir -p /etc/mysql/newcerts/

cd /etc/mysql/newcerts/

3.1 openssl genrsa 2048 > ca-key.pem

3.2 openssl req -new -x509 -nodes -days 1000 -key ca-key.pem > ca-cert.pem

\[root@mysql newcerts\]\# openssl req -new -x509 -nodes -days 1000 -key ca-key.pem > ca-cert.pem

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter '.', the field will be left blank.

\-----

Country Name (2 letter code) \[XX\]:ch

State or Province Name (full name) \[\]:shh

Locality Name (eg, city) \[Default City\]:shh

Organization Name (eg, company) \[Default Company Ltd\]:xx

Organizational Unit Name (eg, section) \[\]:db

Common Name (eg, your name or your server''s hostname) \[\]:mysql.yest.nos

Email Address \[\]:xx@xx.com

3.3 openssl req -newkey rsa:2048 -days 1000 -nodes -keyout server-key.pem > server-req.pem

\[root@mysql newcerts\]\# openssl req -newkey rsa:2048 -days 1000 -nodes -keyout server-key.pem > server-req.pem

Generating a 2048 bit RSA private key

.......................................................................................................+++

..........................................................+++

writing new private key to 'server-key.pem'

\-----

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter '.', the field will be left blank.

\-----

Country Name (2 letter code) \[XX\]:ch

State or Province Name (full name) \[\]:shh

Locality Name (eg, city) \[Default City\]:ssh

Organization Name (eg, company) \[Default Company Ltd\]:xx

Organizational Unit Name (eg, section) \[\]:db

Common Name (eg, your name or your server''s hostname) \[\]:mysql.yest.nos

Email Address \[\]:xx@xx.com

Please enter the following 'extra' attributes

to be sent with your certificate request

A challenge password \[\]:820923

An optional company name \[\]:xx

4 在mysql db server客户端生成ssl文件

4.1 openssl x509 -req -in server-req.pem -days 1000 -CA ca-cert.pem -CAkey ca-key.pem -set\_serial 01 > server-cert.pem

\[root@mysql newcerts\]\# openssl x509 -req -in server-req.pem -days 1000 -CA ca-cert.pem -CAkey ca-key.pem -set\_serial 01 > server-cert.pem

Signature ok

subject=/C=ch/ST=shh/L=ssh/O=ea/OU=db/CN=mysql.yest.nos/emailAddress=cm@xx.com

Getting CA Private Key

4.2 openssl req -newkey rsa:2048 -days 1000 -nodes -keyout client-key.pem > client-req.pem

\[root@mysql newcerts\]\# openssl req -newkey rsa:2048 -days 1000 -nodes -keyout client-key.pem > client-req.pem

Generating a 2048 bit RSA private key

.......+++

........................................................+++

writing new private key to 'client-key.pem'

\-----

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter '.', the field will be left blank.

\-----

Country Name (2 letter code) \[XX\]:ch

State or Province Name (full name) \[\]:shh

Locality Name (eg, city) \[Default City\]:shh

Organization Name (eg, company) \[Default Company Ltd\]:xx

Organizational Unit Name (eg, section) \[\]:db

Common Name (eg, your name or your server''s hostname) \[\]:mysql.yest.nos

Email Address \[\]:cx@xx.com

Please enter the following 'extra' attributes

to be sent with your certificate request

A challenge password \[\]:820923

An optional company name \[\]:xx

4.3

openssl x509 -req -in client-req.pem -days 1000 -CA ca-cert.pem -CAkey ca-key.pem -set\_serial 01 > client-cert.pem

\[root@mysql newcerts\]\# openssl x509 -req -in client-req.pem -days 1000 -CA ca-cert.pem -CAkey ca-key.pem -set\_serial 01 > client-cert.pem

Signature ok

subject=/C=ch/ST=shh/L=shh/O=ea/OU=db/CN=mysql.yest.nos/emailAddress=cm@xx.com

Getting CA Private Key

\[\]copy clent.\* 3个文件到客户端机器上面/opt/mysql/ssl/去。

6 登陆验证

mysql -uxxx -pxxxx --ssl-ca=/opt/mysql/ssl/ca-cert.pem --ssl-cert=/opt/mysql/ssl/server-cert.pem --ssl-key=/opt/mysql/ssl/server-key.pem

conferce：http://www.docin.com/p-151590189.html

![1a1b05c64693fbf380aa1344a7812747.png][]

这篇文章主要介绍了mysql创建删除表的相关资料，非常不错，具有参考借鉴价值，需要的朋友参考下吧2017-10-10

![4f55910a645b073bc4fc65dc10dc14bd.png][]

重置系统后，很久之前安装的MySQL数据库出现了控制台查询中文乱码问题，时间太久早已经不记得怎么设置了。下面通过本文给大家分享Windows10下解决MySQL5.5数据库命令行中文乱码问题，一起看看吧2017-07-07

![0ea3c7666119d5615e582f823fb3fad6.png][]

通过HSODBC访问mysql的实现方法，需要的朋友可以参考下。2009-10-10

![4f96a78db829b1556ff16de21e013c7a.png][]

本文给大家介绍了MySql数据库查询中的特殊命令,包括mysql的安装，特殊查询语句，非常不错，具有参考借鉴价值，需要的朋友可以参考下2017-11-11

![8cc1031babc6aff2319f1c6af8544aa0.png][]

在这篇文章中我们就从连接MYSQL、修改密码、增加用户等方面来学习一些MYSQL的常用命令。2008-08-08

![0c932a99bb7b6f23c937db507070cc7b.png][]

这篇文章主要给大家介绍了关于sqlite3迁移mysql可能遇到的问题集合，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面来一起学习学习吧2019-07-07

![cca732bf65a93ed2ec0ac80c638460fe.png][]

MySQL是一个广泛使用的开源关系型数据库，那如何获取Mysql Docker镜像？下面通过这篇文章来一起看看如何使用DockerHub官方的MySQL镜像，有需要的朋友们可以参考借鉴。2016-12-12

![2d9f31f2af7b675a3d153d2b7f1035a7.png][]

这篇文章主要介绍了Mysql 5.7.19 免安装版配置方法教程详解,需要的朋友可以参考下2017-08-08

![b452cee8ec5cd9e58ab98eba17281e59.png][]

本篇文章对MySQL的数学函数进行了详细的介绍。需要的朋友参考下2013-05-05

![f4838ec7e2d4da28e0b57d4e852dadd4.png][]

这篇文章主要介绍了MySQL存储数据乱码的问题解析,作者从实际使用中的多个方面定位其原因然后解决,需要的朋友可以参考下2015-05-05

mysql名称证书秘钥_mysql通过ssl的方式生成秘钥具体生成步骤

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 git bash生成ssh秘钥

相关 mysql名称证书秘钥_mysql通过ssl的方式生成秘钥具体生成步骤

相关 java生成秘钥key,并保存秘钥到文件中

相关 AndroidStudio 如何生成秘钥？

相关 git生成公钥和秘钥命令

相关 RSA秘钥生成步骤

相关 Linux免密码操作，SSH生成秘钥步骤

相关生成SSH秘钥

相关 PGP生成秘钥对及应用

相关 git生成公匙、秘钥