Hinweis: Dieser Artikel wurde ursprünglich veröffentlicht in 2013. Einige Schritte, Befehle oder Softwareversionen haben sich möglicherweise geändert. Überprüfen Sie die aktuelle Dokumentation von WordPress für die neuesten Informationen.
In this step-by-step guide, you’ll learn connect to a mysql server using ssl from a wordpress site. WordPress is the world’s most popular content management system (CMS), powering over 40% of all websites on the internet.
Voraussetzungen
Bevor Sie beginnen, stellen Sie sicher, dass Sie Folgendes haben:
- WordPress installation (self-hosted)
- Administrator access to WordPress dashboard
- FTP/SFTP or file manager access to server files
How to: Connect to a (http://www.mysql.com “MySQL”) using (http://en.wikipedia.org/wiki/Transport_Layer_Security “Transport Layer Security”) from a (http://wordpress.org “WordPress”) Site
Truly you could title this post simply How to Connect to a MySql server using SSL from a (http://www.php.net “PHP”) application. The key is in the connection construct, which by default in Wordpress it looks sort of like this:
$this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
So here comes the key to the whole business: You must use the “MYSQL_CLIENT_SSL ” client flag to indicate PHP to use SSL. So, in the case of WordPress you could manually open the db.php file and make the manual edit or rely on the parameter $client_flags which is defined as follows:
$client_flags = defined( 'MYSQL_CLIENT_FLAGS' ) ? MYSQL_CLIENT_FLAGS : 0;
So what this means for you is that by defining MYSQL_CLIENT_FLAGS in something like your wp-config.php file you could set the flag to MYSQL_CLIENT_SSL effectively indicating PHP to connect to MySql via SSL. Below is a sample of what to add to your config file:
define(‘MYSQL_CLIENT_FLAGS’, MYSQL_CLIENT_SSL);
Hope this helps!
Zusammenfassung
You’ve successfully learned connect to a mysql server using ssl from a wordpress site. If you run into any issues, double-check the prerequisites and ensure your WordPress environment is properly configured.