Handbuch:$wgDBserver
Datenbank-Einstellungen: $wgDBserver | |
---|---|
Host name or IP address of database server. |
|
Eingeführt in Version: | Vor 1.1.0 |
Entfernt in Version: | Weiterhin vorhanden |
Erlaubte Werte: | (string) |
Standardwert: | 'localhost' |
Andere Einstellungen: Alphabetisch | Nach Funktion |
Details
Database host name or IP address. Found in LocalSettings.php .
If you are using MySQL on a non-standard port, you can use the 'hostname:port'
-syntax, for example $wgDBserver = '127.0.0.1:3308';
.
Note that using a port number when you specify localhost
as the host name will have no effect, as MySQL will connect through a socket instead.
If the MySQL server is on the same server and you want to connect through a socket in a non-standard location, you can use the 'localhost:socket'
-location, for example $wgDBserver = 'localhost:/var/run/mysql/mysql.sock';
.
$wgDBserver = '000.000.000.000';
wird schneller sein als $wgDBserver = "wiki.example.org";
.$wgDBport
is only for PostgreSQL configuration.localhost
for the server name instead of 127.0.0.1
increase the time to connect to the database a lot. So, in windows, it's recommended to use 127.0.0.1
instead of localhost
if MySQL is on the same machine. See this forum thread.It may not work with plain IPv6 addresses, depending on the MySQL driver (libmysqlclient or mysqlnd); this is linked to this PHP bug.
Also, when $wgDBssl
is used, IPv6 addresses in the field subjectAlternativeName of a certificate are not recognised (it was not implemented in PHP when the verification of IPv4 addresses in certificates was implemented [1]).
A workaround for these both cases is to use a DNS name pointing to an IPv6 address.
Siehe auch
- $wgDBservers - for multiple-server (primary/replica) setups or users of custom certificates for SSL encryption where $wgDBssl does not work.