Usual configure switches:

• To compile only the client use --without-server. If you only want to have the client library and don't have a C++ compiler, you can remove the code in configure (in the source distribution) that tests for the C++ compiler and then compile with --without-server. Ignore in this case any warnings about mysql.cc (The only MySQL client that needs C++).
• If you don't want to have your data under `/usr/local/var' use something like: --prefix=/usr/local or --prefix=/usr/local --localstatedir=/usr/local/data/mysql
• If you don't want to have your sockets in the default place (default is `/tmp' or `/var/run') use --with-unix-socket-path=absolute_file_name
• If you get errors compiling sql_yacc.yy errors like: Internal compiler error: program cc1plus got fatal signal 11 or Out of virtual memory you can try the configure switch: --with-low-memory. This adds -fno-inline to the compile line if you are using gcc and -O0 if you are using something else. The problem is that gcc requires about 180M to compile sql_yacc.cc with inline functions.
• If you want to compile the programs staticly for a binary distribution, to get more speed or to go around problems with some RedHat distributions, configure with LDFLAGS=-static ./configure.
• If you are using gcc and don't have g++ or libstdc++ installed you can configure with: CC=gcc CXX=gcc ./configure
• If you don't want to use DEFAULT values at all and you want to get an error for an INSERTs that doesn't use all NOT NULL columns configure with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure.
• Changing the default character set. By default MySQL will use the ISO8859-1 (Latin1) character set. You may change this at compile time by the configure switch --with-charset=charset. Where [charset] may be one of: big5, czech, dec8, dos, german1, hp8, koi8_ru, latin1, latin2, swe7, usa7, ujis, or sjis. See section Character set used for data & sorting. If you want to convert characters between the server and the client, you should take a look at the SET OPTION CHARACTER SET. See section SET OPTION syntax. Warning: If you change character sets after having created a table you will have to run isamchk -r -q on every table. Otherwise things will be sorted incorecctly in some cases (but not all!).
• For computer/OS specific switches, see the menu later in this chapter.

Go to the first, previous, next, last section, table of contents.