mysql

http://dev.mysql.com/downloads/mysql/5.1.html#source

otmanix@pc103835 ~/download/mysql
$ gzip -d mysql-5.1.30.tar.gz

otmanix@pc103835 ~/download/mysql
$ tar -xf mysql-5.1.30.tar 

otmanix@pc103835 ~/download/mysql
$ ls -l
total 144132
drwxr-xr-x+ 33 otmanix Kein         0 Nov 20 00:16 mysql-5.1.30
-rwxr-xr-x   1 otmanix Kein 147589120 Jan  4 14:06 mysql-5.1.30.tar

otmanix@pc103835 ~/download/mysql
$ cd mysql-5.1.30

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ export CC=gcc

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ export CXX=gcc

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ ./configure -prefix=/usr/local -localstatedir=/usr/local/data libexecdir=/usr/local/bin -with-extra-charsets=complex -enable-thread-safe-client -enable-local-infile -disable-shared
checking build system type... i686-pc-cygwin
checking host system type... i686-pc-cygwin
checking target system type... i686-pc-cygwin
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
...
config.status: creating plugin/Makefile
config.status: creating win/Makefile
config.status: creating include/config.h
config.status: executing depfiles commands
config.status: executing default commands

MySQL has a Web site at http://www.mysql.com/ which carries details on the
latest release, upcoming features, and other information to make your
work or play with MySQL more productive. There you can also find
information about mailing lists for MySQL discussion.

Remember to check the platform specific part of the reference manual for
hints about installing MySQL on your platform. Also have a look at the
files in the Docs directory.

Thank you for choosing MySQL!


otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ make
...
make[1]: Leaving directory `/home/otmanix/download/mysql/mysql-5.1.30/server-tools'
Making all in win
make[1]: Entering directory `/home/otmanix/download/mysql/mysql-5.1.30/win'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/otmanix/download/mysql/mysql-5.1.30/win'

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ make install
...
make[2]: Leaving directory `/home/otmanix/download/mysql/mysql-5.1.30/server-tools/instance-manager'
make[1]: Leaving directory `/home/otmanix/download/mysql/mysql-5.1.30/server-tools'
Making install in win
make[1]: Entering directory `/home/otmanix/download/mysql/mysql-5.1.30/win'
make[2]: Entering directory `/home/otmanix/download/mysql/mysql-5.1.30/win'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/home/otmanix/download/mysql/mysql-5.1.30/win'
make[1]: Leaving directory `/home/otmanix/download/mysql/mysql-5.1.30/win'

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ 
otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ mysql_install_db 
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h pc103835 password 'new-password'

Alternatively you can run:
/usr/local/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/


otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ 

$ mysqld&
[1] 1400

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ 090104 21:13:44 [Warning] Setting lower_case_table_names=2 because file system
 for /usr/local/data/ is case insensitive
090104 21:13:44 [Note] Event Scheduler: Loaded 0 events
090104 21:13:44 [Note] mysqld: ready for connections.
Version: '5.1.30'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution


otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$
otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$ mysql -p -u root
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.30 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE mediatomb;
Query OK, 1 row affected (0.09 sec)

mysql> GRANT ALL ON mediatomb.* TO 'otmanix'@'localhost';
Query OK, 0 rows affected (0.11 sec)

mysql> quit
Bye

otmanix@pc103835 ~/download/mysql/mysql-5.1.30
$