Manuale:$wgDBserver
Database settings: $wgDBserver | |
---|---|
Host name or IP address of database server. |
|
Introdotto nella versione: | pre 1.1.0 |
Rimosso nella versione: | still in use |
Valori concessi: | (string) |
Valore predefinito: | 'localhost' |
Impostazioni: Alfabetiche | Per funzione |
Dettagli
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";
.
Tip: Use IP addresses where possible to avoid the overhead of a DNS lookup for every single connection to the wiki.
$wgDBserver = "000.000.000.000";
will be faster than $wgDBserver = "x.y.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.Vedi anche
- $wgDBservers : for multiple-server (master/slave) setups.