Commands To Installing MySQL

• Steps necessary to install a MySQL source distribution are:
  • Add an user.

    groupadd mysql

  • Add a group.

    useradd -g mysql mysql

  • Unpack the distribution into the current directory.

    gunzip < mysql-VERSION.tar.gz | tar -xvf -

  • Change to the newly created directory named mysql-VERSION

    cd mysql-VERSION

  • Run the configure script.

    ./configure --prefix=/usr/local/mysql

  • Compile.

    make

  • Install the distribution as root

    make install

  • Set up an option file, perhaps for support for InnoDB tables, from a template.

    cp support-files/my-medium.cnf /etc/my.cnf

  • Change location into the installation directory.

    cd /usr/local/mysql

  • Change ownership of the newly installed files.

    chown -R mysql:mysql .

  • Create the MySQL data directory and initialize the grant tables.

    bin/mysql_install_db --user=mysql

  • Set appropriate permissions.

    chown -R root .
    

    chown -R mysql var

  • Test the installation.

    bin/mysqld_safe --user=mysql &

• If starting from a source RPM, do the following:

  rpmbuild --rebuild --clean MySQL-VERSION.src.rpm

  • This makes a binary RPM that can be installed.

What are some typical configure options?

---

---

© 2007 John Michael Pierobon

Notes