|Database settings: $wgDBserver|
|Host name or IP address of database server.
|Introduced in version:||pre 1.1.0|
|Removed in version:||still in use|
|Other settings: Alphabetical | By function|
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';will be faster than
$wgDBserver = "wiki.example.org";.
$wgDBportis only for PostgreSQL configuration.
localhostfor the server name instead of
127.0.0.1increase the time to connect to the database a lot. So, in windows, it's recommended to use
localhostif MySQL is on the same machine. See this forum thread.
- $wgDBservers: for multiple-server (master/slave) setups.