How to generate the CA certificate using openssl for mysql or mariadb server

Fig.03: Using the CA key, generate the CA certificate for MariaDB

Fig.03: Using the CA key, generate the CA certificate for MariaDB

Using the CA key, generate the CA certificate for MariaDB/MySQL as follows:
$ openssl genrsa 2048 > ca-key.pem
$ openssl req -new -x509 -nodes -days 365000 -key ca-key.pem -out ca-cert.pem

Sample outputs:

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) [AU]:
State or Province Name (full name) [Some-State]:
Locality Name (eg, city) []:
Organization Name (eg, company) [Internet Widgits Pty Ltd]:
Organizational Unit Name (eg, section) []:
Common Name (e.g. server FQDN or YOUR name) []:192.168.2.45
Email Address []:

Set common name to your servers IP address.

Examples and usage: How to setup MariaDB SSL and secure connections from clients