Comments on Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption)

Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption) This tutorial explains how you can manage multiple MySQL servers from one phpMyAdmin installation. For security reasons, communication between phpMyAdmin and any remote MySQL server is using SSL encryption (this is not necessary for a local MySQL server since communication between phpMyAdmin and MySQL is not leaving the server). phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL.

6 Comment(s)

Add comment

Comments

By:

Falko is in"fal"lible! His tutorials (including DNSSEC) worked every time for me.

By: lmeurs

Great tutorial! Wat startled me was that client certificates were being ignored, I could connect to the database server using an SSL connection without defining client certificates.

The was caused by "REQUIRE SSL" which happens to only require an encrypted connection without checking any certificates. Granting permissions using ie. "REQUIRE X509" requires at least a client key and cert file.

By: Morten

Hi, great article. do you know how to remove the localhost from the drop down menu? so you only can see the other host?

By: Steven

Why didn't you set the -key.pem 's to permission 0600?

By: JaJ

the test using the following command works correctly

mysql --ssl-ca=/etc/mysql/newcerts/ca-cert.pem --ssl-cert=/etc/mysql/newcerts/client-cert.pem --ssl-key=/etc/mysql/newcerts/client-key.pem -h remote.example.com -u root -p

but the connection using phpmyadmin reports an error:

mysqli_real_connect(): SSL operation failed with code 1. OpenSSL Error messages: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol.

Server configuration:

10.3.22-MariaDB-1ubuntu1 - Ubuntu 20.04

Apache/2.4.41 (Ubuntu)

libmysql - mysqlnd 7.4.3

Extension PHP: mysqli curl mbstring

PHP: 7.4.3

phpMyAdmin version: 4.9.5deb2

What's different about ubuntu 20.04 :-(

By: Timothy Leong Cheok Teng

Thank you very much. Your article solved my problem. I checked the source code in dbimysqli.class.php (XAMPP 1.8.3 on Windows 2012) and found the different variable names:

$cfg['Server']['ssl_key'], $cfg['Server']['ssl_cert'], $cfg['Server']['ssl_ca'], $cfg['Server']['ssl_ca_path'], $cfg['Server']['ssl_ciphers'].

That was why my configs in phpmyadmin/config.inc.php were ignored.