|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";.
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";
$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