{{keywords>mybook world edition linux ssh mysql groupadd useradd chmod wget gunzip configure make install chown chgrp mysql_install_db ldd echo ldconfig mysqld_safe ln mysqladmin sql}}
====== Install MySQL ======
<note>First consider fallowing all the previous steps the [[home|WD MyBook World Edition Hacks]] tutorial</note>
<note tip>Please read the official MySQL documentation before proceeding. [[http://dev.mysql.com/doc/refman/5.0/en/installing-source.html|MySQL Installation Using a Source Distribution]]</note>

  *  Add a login user and group for mysqld.
<code>
# groupadd mysql
# useradd -g mysql mysql
</code>

  * Be sure that /tmp directory can be accessed by mysql user.
<code>
# chmod -R 777 /tmp
</code>

  * Choose a directory to unpack the distribution.
<code>
# cd /tmp
</code>

  * Download distribution file. [[http://dev.mysql.com/doc/refman/5.0/en/getting-mysql.html|How to Get MySQL]]
<code>
# wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.51.tar.gz/from/http://ftp.astral.ro/mirrors/mysql.com/
</code>

  * Rename downloaded file.
<code>
# mv index.html mysql-5.0.51.tar.gz
</code>

  * Uncompress source archive.
<code>
# gunzip < mysql-5.0.51.tar.gz | tar xvf -
</code>

  * Change the location in unpacked distribution directory.
<code>
# cd mysql-5.0.51
</code>

  * Configure the release and compile everything [[http://dev.mysql.com/doc/refman/5.0/en/configure-options.html|Typical configure Options]]
<code>
# ./configure --prefix=/usr/local/mysql --with-low-memory
# make
</code>

  * Install the distribution.
<code>
# make install
</code>

  * Setup an option file.
<code>
# cp support-files/my-medium.cnf /etc/my.cnf
</code>

  * Change location in the installation directory.
<code>
# cd /usr/local/mysql
</code>

  * Assign mysql user and group to installed files.
<code>
# chown -R mysql .
# chgrp -R mysql .
</code>

  * Create the mysql data directory and initialize the grant tables.
<code>
# bin/mysql_install_db --user=mysql
</code>

  * Add shared libraries and mysql library path.
<code>
# ldd /usr/local/mysql/bin/mysql
# echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
# ldconfig
</code>

  * Assing mysql user to data directory.
<code>
# chown -R root .
# chown -R mysql var
</code>

  * Start mysql server.
<code>
# bin/mysqld_safe --user=mysql &
</code>

  * To start mysql server automaticaly when device is started:
<code>
# cp support-files/mysql.server /etc/init.d/mysql
# chmod +x /etc/init.d/mysql
# ln -s /etc/init.d/mysql /etc/init.d/S40mysql
</code>

  * Test mysql server. [[http://dev.mysql.com/doc/refman/5.0/en/post-installation.html|Post-Installation Setup and Testing]]
<code>
# bin/mysqladmin version
# bin/mysqladmin variables
# bin/mysqlshow
# bin/mysqlshow mysql
# less /etc/my.cnf 
</code>

  * Login to the mysqlserver and set root password.
<code>
# bin/mysql
</code>

<code mysql>
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'HOST_NAME' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
DROP USER '';
DROP USER ''@'localhost';
DROP USER ''@'HOST_NAME';
</code>