As mentioned in this *guide(1), i've compiled mysql on my fedora Core
2 system, with the following spec's :
*(1) http://hulan.info/blog/index.php?itemid=576
--------------- bash START --------------
$ uname -a
Linux localhost.local domain 2.6.8-1.521 #1 Mon Aug 16 09:01:18 EDT
2004 i686 ath
lon i386 GNU/Linux
$ gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.3.3/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/u
sr/share/info --enable-shared --enable-threads=posix
--disable-checking --disabl
e-libunwind-exceptions --with-system-zlib --enable-__cxa_atexit
--host=i386-redh
at-linux
Thread model: posix
gcc version 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
$ ldd --version
ldd (GNU libc) 2.3.3
$ rpm -qa | grep libtermcap
libtermcap-2.0.8-38
libtermcap-devel-2.0.8-38
$ export CFLAGS="-march=athlon-xp -mcpu=athlon-xp -mfpmath=sse -msse2
-O2 -pipe -s -fomit-frame-pointer"
$ export CPPFLAGS="-march=athlon-xp -mcpu=athlon-xp -mfpmath=sse
-msse2 -O2 -pipe -s -fomit-frame-pointer"
$ cd /usr/local/src/mysql-4.1.6-gamma
$ ./configure \
--prefix=/usr/local/mysql \
--with-unix-sock-path=/tmp/mysql.sock \
--with-charset=utf8
$ make
$ make install
--------------- bash END --------------
when i get to the stage of creating the initial database this is what
happens :
--------------- bash START --------------
$ /usr/local/mysql/bin/mysql_install_d b --user=mysql
mkdir: cannot create directory `/usr/local/mysql/var/mysql':
Permission denied
chmod: cannot access `/usr/local/mysql/var/mysql': Permission denied
mkdir: cannot create directory `/usr/local/mysql/var/test': Permission
denied
chmod: cannot access `/usr/local/mysql/var/test': Permission denied
Installing all prepared tables
bin/mysql_install_d b: line 1: 3185 Illegal instruction
/usr/local/mysql/libexec/mysqld --bootstrap --skip-grant-tables
--basedir=/usr/local/mysql --datadir=/usr/local/mysql/var
--skip-innodb --skip-bdb --skip-ndbcluster --user=mysql
--max_allowed_pac ket=8M
/usr/local/mysql/bin/mysql_create_sy stem_tables: line 664: 3186
Broken pipe cat <<END_OF_DATA
use mysql;
$c_d
$i_d
$c_h
$i_h
$c_u
$i_u
$c_f
$i_f
$c_t
$c_c
$c_ht
$c_hc
$c_hr
$c_hk
$c_tzn
$i_tzn
$c_tz
$i_tz
$c_tzt
$i_tzt
$c_tztt
$i_tztt
$c_tzls
$i_tzls
END_OF_DATA
Installation of system tables failed!
Examine the logs in /usr/local/mysql/var for more information.
--------------- bash END --------------
the logs contatin nothing useful.
here is the permissions on the folder, tough it's pretty useless as i
run the script as root
--------------- bash START --------------
$ ls -la /usr/local/mysql/var/
total 20
drwx------ 4 mysql root 4096 Oct 21 18:10 .
drwxr-xr-x 12 root root 4096 Oct 21 05:11 ..
-rw-rw---- 1 mysql root 94 Oct 21 18:12 localhost.local domain.err
drwx------ 2 mysql root 4096 Oct 21 05:11 mysql
drwx------ 2 mysql root 4096 Oct 21 05:11 test
--------------- bash END --------------
on boot i get the following message :
--------------- bash START --------------
localhost login: /usr/local/mysql/bin/mysqld_safe: line 1: 2480
Illegal instruction nohup /usr/local/mysql/libexec/mysqld
--basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/localhost.local domain.pid
--skip-locking --port=3306 --socket=/tmp/mysql.sock
/usr/local/mysql/var/localhost.local domain.err 2>&1
STOPPING server from pid file
/usr/local/mysql/var/localhost.local domain.pid
041021 18:12:18 mysqld ended
--------------- bash END --------------
help ? (:
Thank you, Maxim Vexler.