after trial n error and reading:
http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html
gcc -v
i learned the hard way that mysql and gcc operates on default /usr/local or /usr/bin or /usr/local/mysql for incuding header & lib files. so if i get an error message no file or directory found: i have to explicitly set -I or -L or use the cmake or make options to override defaults and to search additional paths. also i tried setting environment variables. deviating from default introduces ??? tested using perl mysql-test-run.pl. after countless tries n errors n hours they worked for me to get my db up and running. thanks to free software and free docs. start writing some code.
noel
attached output:
root@masipag:/usr/local/mysql# scripts/mysql_install_db --user=mysql
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:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h masipag password 'new-password'
Alternatively you can run:
./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 . ; ./bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl
Please report any problems with the ./bin/mysqlbug script!
root@masipag:/usr/local/mysql# ls -al
total 84
drwxr-sr-x 13 mysql mysql 4096 Apr 20 23:10 .
drwxrwsr-x 16 root staff 4096 Apr 20 23:08 ..
drwxr-sr-x 2 mysql mysql 4096 Apr 20 23:10 bin
-rw-r--r-- 1 mysql mysql 17987 Mar 31 06:36 COPYING
drwxr-sr-x 5 mysql mysql 4096 Apr 21 11:53 data
drwxr-xr-x 2 mysql mysql 4096 Apr 20 23:08 docs
drwxr-sr-x 3 mysql mysql 4096 Apr 20 23:08 include
-rw-r--r-- 1 mysql mysql 7370 Mar 31 06:36 INSTALL-BINARY
drwxr-sr-x 3 mysql mysql 4096 Apr 20 23:08 lib
drwxr-sr-x 4 mysql mysql 4096 Apr 20 23:10 man
drwxr-xr-x 10 mysql mysql 4096 Apr 20 23:10 mysql-test
-rw-r--r-- 1 mysql mysql 2552 Mar 31 06:36 README
drwxr-sr-x 2 mysql mysql 4096 Apr 20 23:10 scripts
drwxr-sr-x 27 mysql mysql 4096 Apr 20 23:10 share
drwxr-sr-x 4 mysql mysql 4096 Apr 20 23:10 sql-bench
drwxr-sr-x 2 mysql mysql 4096 Apr 20 23:10 support-files
root@masipag:/usr/local/mysql# chown -R root .
root@masipag:/usr/local/mysql# chown -R mysql data
root@masipag:/usr/local/mysql# ls -al
total 84
drwxr-sr-x 13 root mysql 4096 Apr 20 23:10 .
drwxrwsr-x 16 root staff 4096 Apr 20 23:08 ..
drwxr-sr-x 2 root mysql 4096 Apr 20 23:10 bin
-rw-r--r-- 1 root mysql 17987 Mar 31 06:36 COPYING
drwxr-sr-x 5 mysql mysql 4096 Apr 21 11:53 data
drwxr-xr-x 2 root mysql 4096 Apr 20 23:08 docs
drwxr-sr-x 3 root mysql 4096 Apr 20 23:08 include
-rw-r--r-- 1 root mysql 7370 Mar 31 06:36 INSTALL-BINARY
drwxr-sr-x 3 root mysql 4096 Apr 20 23:08 lib
drwxr-sr-x 4 root mysql 4096 Apr 20 23:10 man
drwxr-xr-x 10 root mysql 4096 Apr 20 23:10 mysql-test
-rw-r--r-- 1 root mysql 2552 Mar 31 06:36 README
drwxr-sr-x 2 root mysql 4096 Apr 20 23:10 scripts
drwxr-sr-x 27 root mysql 4096 Apr 20 23:10 share
drwxr-sr-x 4 root mysql 4096 Apr 20 23:10 sql-bench
drwxr-sr-x 2 root mysql 4096 Apr 20 23:10 support-files
root@masipag:/usr/local/mysql# cd mysql-test/
root@masipag:/usr/local/mysql/mysql-test# perl mysql-test-run.pl
Logging: mysql-test-run.pl
110421 12:16:37 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.5.11
Checking supported features...
- skipping ndbcluster
- SSL connections supported
Collecting tests...
- adding combinations for binlog
- adding combinations for rpl
vardir: /usr/local/mysql/mysql-test/var
Removing old var directory...
Creating var directory '/usr/local/mysql/mysql-test/var'...
Installing system database...
Using server port 60207
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
binlog.binlog_multi_engine [ skipped ] No ndbcluster tests(--skip-ndbcluster)
main.bug46080 [ skipped ] Test needs debug binaries
main.count_distinct3 [ skipped ] Test needs 'big-test' option
main.crash_commit_before [ skipped ] Test needs debug binaries
main.ctype_like_range [ skipped ] Test needs debug binaries
main.drop_debug [ skipped ] Test needs debug binaries
main.error_simulation [ skipped ] Test needs debug binaries
main.events_stress [ skipped ] Test needs 'big-test' option
main.events_time_zone [ skipped ] Test needs 'big-test' option
main.filesort_debug [ skipped ] Test needs debug binaries
main.flush_read_lock_kill [ skipped ] Test needs debug binaries
main.information_schema-big [ skipped ] Test needs 'big-test' option
main.log_tables_debug [ skipped ] Test needs debug binaries
main.merge-big [ skipped ] Test needs 'big-test' option
main.myisam_crash_before_flush_keys [ skipped ] Test needs debug binaries
main.myisam_debug [ skipped ] Test needs debug binaries
main.mysqlbinlog_row_big [ skipped ] Test needs 'big-test' option
main.partition_sync [ skipped ] Test needs debug binaries