Thread:Project:Support desk/MediaWiki Building failure——Mysql connection issue/reply

my.cnf:
 * 1) Example MySQL config file for medium systems.
 * 2) This is for a system with little memory (32M - 64M) where MySQL plays
 * 3) an important part, or systems up to 128M where MySQL is used together with
 * 4) other programs (such as a web server)
 * 5) You can copy this file to
 * 6) /etc/my.cnf to set global options,
 * 7) mysql-data-dir/my.cnf to set server-specific options (in this
 * 8) installation this directory is /var/lib/mysql) or
 * 9) ~/.my.cnf to set user-specific options.
 * 10) In this file, you can use all long options that a program supports.
 * 11) If you want to know which options a program supports, run the program
 * 12) with the "--help" option.
 * 1) In this file, you can use all long options that a program supports.
 * 2) If you want to know which options a program supports, run the program
 * 3) with the "--help" option.

[client] port           = 3306 socket         = /var/lib/mysql/mysql.sock
 * 1) The following options will be passed to all MySQL clients
 * 1) password      = your_password


 * 1) Here follows entries for some specific programs

[mysqld] port           = 3306 socket         = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M
 * 1) The MySQL server


 * 1) Don't listen on a TCP/IP port at all. This can be a security enhancement,
 * 2) if all processes that need to connect to mysqld run on the same host.
 * 3) All interaction with mysqld must be made via Unix sockets or named pipes.
 * 4) Note that using this option without enabling named pipes on Windows
 * 5) (via the "enable-named-pipe" option) will render mysqld useless!
 * 6) skip-networking
 * 1) skip-networking

skip-federated
 * 1) Disable Federated by default

log-bin=mysql-bin
 * 1) Replication Master Server (default)
 * 2) binary logging is required for replication

server-id      = 1
 * 1) required unique id between 1 and 2^32 - 1
 * 2) defaults to 1 if master-host is not set
 * 3) but will not function as a master if omitted


 * 1) Replication Slave (comment out master section to use this)
 * 2) To configure this host as a replication slave, you can choose between
 * 3) two methods :
 * 4) 1) Use the CHANGE MASTER TO command (fully described in our manual) -
 * 5)    the syntax is:
 * 6)    CHANGE MASTER TO MASTER_HOST=, MASTER_PORT= ,
 * 7)    MASTER_USER=, MASTER_PASSWORD= ;
 * 8)    where you replace, , by quoted strings and
 * 9)    by the master's port number (3306 by default).
 * 10)    Example:
 * 11)    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
 * 12)    MASTER_USER='joe', MASTER_PASSWORD='secret';
 * OR
 * 1) 2) Set the variables below. However, in case you choose this method, then
 * 2)    start replication for the first time (even unsuccessfully, for example
 * 3)    if you mistyped the password in master-password and the slave fails to
 * 4)    connect), the slave will create a master.info file, and any later
 * 5)    change in this file to the variables' values below will be ignored and
 * 6)    overridden by the content of the master.info file, unless you shutdown
 * 7)    the slave server, delete master.info and restart the slaver server.
 * 8)    For that reason, you may want to leave the lines below untouched
 * 9)    (commented) and instead use CHANGE MASTER TO (see above)
 * 10) required unique id between 2 and 2^32 - 1
 * 11) (and different from the master)
 * 12) defaults to 2 if master-host is set
 * 13) but will not function as a slave if omitted
 * 14) server-id      = 2
 * 15) The replication master for this slave - required
 * 16) master-host    =
 * 17) The username the slave will use for authentication when connecting
 * 18) to the master - required
 * 19) master-user    =
 * 20) The password the slave will authenticate with when connecting to
 * 21) the master - required
 * 22) master-password =
 * 23) The port the master is listening on.
 * 24) optional - defaults to 3306
 * 25) master-port    =
 * 26) binary logging - not required for slaves, but recommended
 * 27) log-bin=mysql-bin
 * 1) The username the slave will use for authentication when connecting
 * 2) to the master - required
 * 3) master-user    =
 * 4) The password the slave will authenticate with when connecting to
 * 5) the master - required
 * 6) master-password =
 * 7) The port the master is listening on.
 * 8) optional - defaults to 3306
 * 9) master-port    =
 * 10) binary logging - not required for slaves, but recommended
 * 11) log-bin=mysql-bin
 * 1) binary logging - not required for slaves, but recommended
 * 2) log-bin=mysql-bin
 * 1) log-bin=mysql-bin


 * 1) Point the following paths to different dedicated disks
 * 2) tmpdir        = /tmp/
 * 3) log-update    = /path-to-dedicated-directory/hostname


 * 1) Uncomment the following if you are using BDB tables
 * 2) bdb_cache_size = 4M
 * 3) bdb_max_lock = 10000


 * 1) Uncomment the following if you are using InnoDB tables
 * 2) innodb_data_home_dir = /var/lib/mysql/
 * 3) innodb_data_file_path = ibdata1:10M:autoextend
 * 4) innodb_log_group_home_dir = /var/lib/mysql/
 * 5) innodb_log_arch_dir = /var/lib/mysql/
 * 6) You can set .._buffer_pool_size up to 50 - 80 %
 * 7) of RAM but beware of setting memory usage too high
 * 8) innodb_buffer_pool_size = 16M
 * 9) innodb_additional_mem_pool_size = 2M
 * 10) Set .._log_file_size to 25 % of buffer pool size
 * 11) innodb_log_file_size = 5M
 * 12) innodb_log_buffer_size = 8M
 * 13) innodb_flush_log_at_trx_commit = 1
 * 14) innodb_lock_wait_timeout = 50

[mysqldump] quick max_allowed_packet = 16M

[mysql] no-auto-rehash
 * 1) Remove the next comment character if you are not familiar with SQL
 * 2) safe-updates

[isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M

[myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M

[mysqlhotcopy] interactive-timeout