debian cmake安装mysql,MySQL :: Help on Debian Source building mysql 5.5.10 w/ CMake

Help on Debian Source building mysql 5.5.10 w/ CMake

Posted by: Noel Cruz

Date: April 02, 2011 10:01PM

Hi, I tried building from source mysql ga 5.5.10 using cmake. It built and installed into /usr/local/mysql using the online docs and accepted the defaults like:

cmake . # unlike ./configure

make

make install

My problem started when I tried the post-install w/ okako:/usr/local/mysql# scripts/mysql_install_db --user=mysql. As a workaround, I did okako:/usr/local/mysql# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ and ran mysqld in libexec and I get these errors in another terminal:

okkaba@okako:/usr/local/mysql/bin$ ./mysql -u root

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

okkaba@okako:/usr/local/mysql/bin$ ./mysql -u root mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

okkaba@okako:/usr/local/mysql/bin$ ./mysql -u mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

okkaba@okako:/usr/local/mysql/bin$ ./mysql -u mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

okkaba@okako:/usr/local/mysql/bin$ ./mysql -u root mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

okkaba@okako:/usr/local/mysql/bin$

I was going to rerun cmake . w/ new options but checking CMakeCache.txt shows that default basedir is /usr/local/mysql. To summarize, it compiles and builds but I cannot connect to server. Any help will be appreciated!

thanks in advance, noel s cruz - vancouver, bc

attached are my notes:

notes1 on mysql 5.5.10april 2, 2011

unpacked mysql 5.5.10

updated ncurses from 5.7 to 5.8

**************

to clean stored configuration from failed builds:

$ make distclean at untar dir or

$ rm config.cache

$ make clean

run ./configure again

**************

http://forge.mysql.com/wiki/CMake

$ make clean

$ rm CMakeCache.txt

$ cmake .

**************

/bin/sh ./run_tic.sh

** Building terminfo database, please wait...

Running tic to install /usr/share/terminfo ...

You may see messages regarding extended capabilities, e.g., AX.

These are extended terminal capabilities which are compiled

using

tic -x

If you have ncurses 4.2 applications, you should read the INSTALL

document, and install the terminfo without the -x option.

1600 entries written to /usr/share/terminfo

** built new /usr/share/terminfo

** sym-linked /usr/lib/terminfo for compatibility

installing std

installing stdcrt

installing vt100

installing vt300

/usr/bin/install -c ncurses-config /usr/bin/ncurses5-config

make[1]: Leaving directory `/home/okkaba/gnu/ncurses/ncurses-5.8/misc'

cd c++ && make DESTDIR="" install

make[1]: Entering directory `/home/okkaba/gnu/ncurses/ncurses-5.8/c++'

/usr/bin/install -c -m 644 ../lib/libncurses++.a /usr/lib/libncurses++.a

installing ./cursesapp.h in /usr/include

installing ./cursesf.h in /usr/include

installing ./cursesm.h in /usr/include

installing ./cursesp.h in /usr/include

installing ./cursesw.h in /usr/include

installing ./cursslk.h in /usr/include

installing etip.h in /usr/include

make[1]: Leaving directory `/home/okkaba/gnu/ncurses/ncurses-5.8/c++'

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# quit

bash: quit: command not found

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# exit

exit

okkaba@okako:~/gnu/ncurses/ncurses-5.8$ which cmake

okkaba@okako:~/gnu/ncurses/ncurses-5.8$ su

Password:

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# apt-get install cmake cmake-gui

Reading package lists... Done

Building dependency tree

Reading state information... Done

E: Couldn't find package cmake-gui

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# apt-get install cmake

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

libxmlrpc-c3

The following NEW packages will be installed:

cmake libxmlrpc-c3

0 upgraded, 2 newly installed, 0 to remove and 101 not upgraded.

Need to get 7131kB of archives.

After this operation, 18.4MB of additional disk space will be used.

Do you want to continue [Y/n]? y

Get:1 http://ftp.us.debian.org lenny/main libxmlrpc-c3 1.06.27-1 [244kB]

Get:2 http://ftp.us.debian.org lenny/main cmake 2.6.0-6 [6888kB]

Fetched 7131kB in 6s (1159kB/s)

Selecting previously deselected package libxmlrpc-c3.

(Reading database ... 99496 files and directories currently installed.)

Unpacking libxmlrpc-c3 (from .../libxmlrpc-c3_1.06.27-1_i386.deb) ...

Selecting previously deselected package cmake.

Unpacking cmake (from .../cmake_2.6.0-6_i386.deb) ...

Processing triggers for man-db ...

Processing triggers for menu ...

Setting up libxmlrpc-c3 (1.06.27-1) ...

Setting up cmake (2.6.0-6) ...

Processing triggers for menu ...

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# groupadd mysql

groupadd: group mysql exists

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# useradd -r -g mysql mysql

useradd: user mysql exists

okako:/home/okkaba/gnu/ncurses/ncurses-5.8# exit

exit

okkaba@okako:~/gnu/ncurses/ncurses-5.8$ cd ~

okkaba@okako:~$ cd mysql

okkaba@okako:~/mysql$ ls -al

total 69996

drwxr-xr-x 3 okkaba okkaba 4096 2011-04-02 18:31 .

drwxr-xr-x 78 okkaba okkaba 4096 2011-04-02 18:31 ..

drwxr-xr-x 33 okkaba okkaba 4096 2010-10-22 11:52 mysql-5.1.51

-r-------- 1 okkaba okkaba 23830456 2010-10-19 18:45 mysql-5.1.51.tar.gz

-rw------- 1 okkaba okkaba 23841760 2010-11-10 09:54 mysql-5.1.52.tar.gz

-r-------- 1 okkaba okkaba 23877968 2011-04-02 16:55 mysql-5.5.10.tar.gz

-rw-r--r-- 1 okkaba okkaba 3428 2011-04-02 18:31 notes1_mysql.txt

-rw-r--r-- 1 okkaba okkaba 3191 2011-04-02 18:26 notes1_mysql.txt~

-rw-r--r-- 1 okkaba okkaba 4593 2010-10-22 12:08 notes_mysql.txt

-rw-r--r-- 1 okkaba okkaba 4127 2010-10-22 12:03 notes_mysql.txt~

okkaba@okako:~/mysql$ tar -xvzf mysql-5.5.10.tar.gz

...

okkaba@okako:~/mysql$ cd mysql-5.5.10/

okkaba@okako:~/mysql/mysql-5.5.10$ cmake .

...

-- Found Curses: /usr/lib/libcurses.a

-- Looking for tputs in /usr/lib/libcurses.a

-- Looking for tputs in /usr/lib/libcurses.a - found

-- Performing Test HAVE_DECL_TGOTO

-- Performing Test HAVE_DECL_TGOTO - Success

-- Looking for strvis

-- Looking for strvis - not found

-- Looking for strunvis

-- Looking for strunvis - not found

-- Looking for include files HAVE_LIBAIO_H

-- Looking for include files HAVE_LIBAIO_H - not found.

-- Looking for io_queue_init in aio

-- Looking for io_queue_init in aio - not found

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS - Success

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC - Success

-- Check size of pthread_t

-- Check size of pthread_t - done

-- Performing Test HAVE_PEERCRED

-- Performing Test HAVE_PEERCRED - Success

-- Configuring done

-- Generating done

-- Build files have been written to: /home/okkaba/mysql/mysql-5.5.10

okkaba@okako:~/mysql/mysql-5.5.10$ make

...

[ 96%] Building CXX object sql/CMakeFiles/sql.dir/sql_connect.cc.o

[ 97%] Building CXX object sql/CMakeFiles/sql.dir/scheduler.cc.o

[ 97%] Building CXX object sql/CMakeFiles/sql.dir/sql_partition_admin.cc.o

[ 97%] Building CXX object sql/CMakeFiles/sql.dir/sql_profile.cc.o

[ 97%] Building CXX object sql/CMakeFiles/sql.dir/event_parse_data.cc.o

[ 97%] Building CXX object sql/CMakeFiles/sql.dir/sql_alter.cc.o

[ 97%] Building CXX object sql/CMakeFiles/sql.dir/sql_signal.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/rpl_handler.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/mdl.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/sql_admin.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/transaction.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/sys_vars.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/sql_truncate.cc.o

[ 98%] Building CXX object sql/CMakeFiles/sql.dir/datadict.cc.o

[ 99%] Building CXX object sql/CMakeFiles/sql.dir/sql_reload.cc.o

[ 99%] Building CXX object sql/CMakeFiles/sql.dir/sql_yacc.cc.o

[ 99%] Building CXX object sql/CMakeFiles/sql.dir/sql_builtin.cc.o

Linking CXX static library libsql.a

[ 99%] Built target sql

Scanning dependencies of target mysqld

[100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o

Linking CXX executable mysqld

[100%] Built target mysqld

Scanning dependencies of target udf_example

[100%] Building C object sql/CMakeFiles/udf_example.dir/udf_example.c.o

Linking C shared module udf_example.so

[100%] Built target udf_example

Scanning dependencies of target my_safe_process

[100%] Building CXX object mysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o

Linking CXX executable my_safe_process

[100%] Built target my_safe_process

okkaba@okako:~/mysql/mysql-5.5.10$ su

Password:

okako:/home/okkaba/mysql/mysql-5.5.10# make install

...

-- Installing: /usr/local/mysql/man/man1/mysql.1

-- Installing: /usr/local/mysql/man/man1/mysql_install_db.1

-- Installing: /usr/local/mysql/man/man1/mysqlhotcopy.1

-- Installing: /usr/local/mysql/man/man1/mysql_secure_installation.1

-- Installing: /usr/local/mysql/man/man1/mysqlshow.1

-- Installing: /usr/local/mysql/man/man1/mysql-stress-test.pl.1

-- Installing: /usr/local/mysql/man/man1/mysqlcheck.1

-- Installing: /usr/local/mysql/man/man1/mysqldumpslow.1

-- Installing: /usr/local/mysql/man/man1/mysql.server.1

-- Installing: /usr/local/mysql/man/man1/mysqldump.1

-- Installing: /usr/local/mysql/man/man1/perror.1

-- Installing: /usr/local/mysql/man/man1/mysqlbug.1

-- Installing: /usr/local/mysql/man/man1/mysql_setpermission.1

-- Installing: /usr/local/mysql/man/man8/mysqld.8

okako:/home/okkaba/mysql/mysql-5.5.10# cd /usr/local/mysql

okako:/usr/local/mysql# ls -al

total 200

drwxr-sr-x 14 mysql mysql 4096 2011-04-02 18:47 .

drwxrwsr-x 14 root staff 4096 2010-10-23 13:49 ..

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 bin

-rw-r--r-- 1 root mysql 17987 2011-03-09 07:11 COPYING

drwxr-sr-x 4 root mysql 4096 2011-04-02 18:47 data

drwxr-xr-x 2 mysql mysql 4096 2011-04-02 18:47 docs

drwxr-sr-x 3 mysql mysql 4096 2011-04-02 18:47 include

-rw-r--r-- 1 root mysql 7370 2011-03-09 07:11 INSTALL-BINARY

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 lib

drwxr-sr-x 2 mysql mysql 4096 2010-10-22 11:52 libexec

drwxr-sr-x 4 root mysql 4096 2011-04-02 18:47 man

drwxr-xr-x 10 mysql mysql 4096 2011-04-02 18:47 mysql-test

-rw-r--r-- 1 root mysql 114014 2011-03-09 07:11 README

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 scripts

drwxr-sr-x 29 mysql mysql 4096 2011-04-02 18:47 share

drwxr-sr-x 5 mysql mysql 4096 2011-04-02 18:47 sql-bench

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 support-files

okako:/usr/local/mysql# chown -R mysql .

okako:/usr/local/mysql# chgrp -R mysql .

okako:/usr/local/mysql# scripts/mysql_install_db --user=mysql

FATAL ERROR: Could not find mysqld

The following directories were searched:

/usr/libexec

/usr/sbin

/usr/bin

If you compiled from source, you need to run 'make install' to

copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top

level of the extracted archive, or pass the --basedir option

pointing to that location.

okako:/usr/local/mysql# ls -al

total 200

drwxr-sr-x 14 mysql mysql 4096 2011-04-02 18:47 .

drwxrwsr-x 14 root staff 4096 2010-10-23 13:49 ..

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 bin

-rw-r--r-- 1 mysql mysql 17987 2011-03-09 07:11 COPYING

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 data

drwxr-xr-x 2 mysql mysql 4096 2011-04-02 18:47 docs

drwxr-sr-x 3 mysql mysql 4096 2011-04-02 18:47 include

-rw-r--r-- 1 mysql mysql 7370 2011-03-09 07:11 INSTALL-BINARY

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 lib

drwxr-sr-x 2 mysql mysql 4096 2010-10-22 11:52 libexec

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 man

drwxr-xr-x 10 mysql mysql 4096 2011-04-02 18:47 mysql-test

-rw-r--r-- 1 mysql mysql 114014 2011-03-09 07:11 README

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 scripts

drwxr-sr-x 29 mysql mysql 4096 2011-04-02 18:47 share

drwxr-sr-x 5 mysql mysql 4096 2011-04-02 18:47 sql-bench

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 support-files

okako:/usr/local/mysql# chown -R root .

okako:/usr/local/mysql# chown -R mysql data

okako:/usr/local/mysql# ls -al

total 200

drwxr-sr-x 14 root mysql 4096 2011-04-02 18:47 .

drwxrwsr-x 14 root staff 4096 2010-10-23 13:49 ..

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 bin

-rw-r--r-- 1 root mysql 17987 2011-03-09 07:11 COPYING

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 data

drwxr-xr-x 2 root mysql 4096 2011-04-02 18:47 docs

drwxr-sr-x 3 root mysql 4096 2011-04-02 18:47 include

-rw-r--r-- 1 root mysql 7370 2011-03-09 07:11 INSTALL-BINARY

drwxr-sr-x 4 root mysql 4096 2011-04-02 18:47 lib

drwxr-sr-x 2 root mysql 4096 2010-10-22 11:52 libexec

drwxr-sr-x 4 root mysql 4096 2011-04-02 18:47 man

drwxr-xr-x 10 root mysql 4096 2011-04-02 18:47 mysql-test

-rw-r--r-- 1 root mysql 114014 2011-03-09 07:11 README

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 scripts

drwxr-sr-x 29 root mysql 4096 2011-04-02 18:47 share

drwxr-sr-x 5 root mysql 4096 2011-04-02 18:47 sql-bench

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 support-files

okako:/usr/local/mysql# ls -al /usr/local/mysql/bin/

total 124320

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 .

drwxr-sr-x 14 root mysql 4096 2011-04-02 18:47 ..

-rwxr-xr-x 1 root mysql 19246 2011-04-02 18:40 innochecksum

-rwxr-xr-x 1 root mysql 1424 2011-04-02 18:36 msql2mysql

-rwxr-xr-x 1 root mysql 5410497 2011-04-02 18:46 myisamchk

-rwxr-xr-x 1 root mysql 5080694 2011-04-02 18:46 myisam_ftdump

-rwxr-xr-x 1 root mysql 5071614 2011-04-02 18:46 myisamlog

-rwxr-xr-x 1 root mysql 5139044 2011-04-02 18:46 myisampack

-rwxr-xr-x 1 root mysql 3587056 2011-04-02 18:40 my_print_defaults

-rwxr-xr-x 1 root mysql 4615022 2011-04-02 18:40 mysql

-rwxr-xr-x 1 root mysql 111585 2011-04-02 18:36 mysqlaccess

-rwxr-xr-x 1 root mysql 1702 2011-03-09 07:11 mysqlaccess.conf

-rwxr-xr-x 1 root mysql 3986310 2011-04-02 18:40 mysqladmin

-rwxr-xr-x 1 root mysql 4444526 2011-04-02 18:47 mysqlbinlog

-rwxr-xr-x 1 root mysql 10643 2011-04-02 18:36 mysqlbug

-rwxr-xr-x 1 root mysql 3975252 2011-04-02 18:40 mysqlcheck

-rwxr-xr-x 1 root mysql 4583605 2011-04-02 18:40 mysql_client_test

-rwxr-xr-x 1 root mysql 6685 2011-04-02 18:36 mysql_config

-rwxr-xr-x 1 root mysql 4169 2011-04-02 18:36 mysql_convert_table_format

-rwxr-xr-x 1 root mysql 35132253 2011-04-02 18:47 mysqld

-rwxr-xr-x 1 root mysql 23366 2011-04-02 18:36 mysqld_multi

-rwxr-xr-x 1 root mysql 22139 2011-04-02 18:36 mysqld_safe

-rwxr-xr-x 1 root mysql 4127706 2011-04-02 18:41 mysqldump

-rwxr-xr-x 1 root mysql 7351 2011-04-02 18:36 mysqldumpslow

-rwxr-xr-x 1 root mysql 3245 2011-04-02 18:36 mysql_find_rows

-rwxr-xr-x 1 root mysql 1226 2011-04-02 18:36 mysql_fix_extensions

-rwxr-xr-x 1 root mysql 5894 2010-10-22 11:52 mysql_fix_privilege_tables

-rwxr-xr-x 1 root mysql 32805 2011-04-02 18:36 mysqlhotcopy

-rwxr-xr-x 1 root mysql 3981715 2011-04-02 18:41 mysqlimport

-rwxr-xr-x 1 root mysql 14361 2010-10-22 11:52 mysql_install_db

-rwxr-xr-x 1 root mysql 8033 2011-04-02 18:36 mysql_secure_installation

-rwxr-xr-x 1 root mysql 17438 2011-04-02 18:36 mysql_setpermission

-rwxr-xr-x 1 root mysql 3971170 2011-04-02 18:41 mysqlshow

-rwxr-xr-x 1 root mysql 4018817 2011-04-02 18:41 mysqlslap

-rwxr-xr-x 1 root mysql 4439934 2011-04-02 18:41 mysqltest

-rwxr-xr-x 1 root mysql 3453565 2011-04-02 18:47 mysql_tzinfo_to_sql

-rwxr-xr-x 1 root mysql 3700146 2011-04-02 18:40 mysql_upgrade

-rwxr-xr-x 1 root mysql 3582466 2011-04-02 18:40 mysql_waitpid

-rwxr-xr-x 1 root mysql 3818 2011-04-02 18:36 mysql_zap

-rwxr-xr-x 1 root mysql 3685848 2011-04-02 18:40 perror

-rwxr-xr-x 1 root mysql 3544146 2011-04-02 18:40 replace

-rwxr-xr-x 1 root mysql 3584242 2011-04-02 18:40 resolveip

-rwxr-xr-x 1 root mysql 3592373 2011-04-02 18:40 resolve_stack_dump

okako:/usr/local/mysql# scripts/mysql_install_db --user=mysql \

> --basedir=/usr/local/mysql/bin \

> --datadir=/usr/local/mysql/data

FATAL ERROR: Could not find my_print_defaults

The following directories were searched:

/usr/local/mysql/bin/bin

/usr/local/mysql/bin/extra

If you compiled from source, you need to run 'make install' to

copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top

level of the extracted archive, or pass the --basedir option

pointing to that location.

okako:/usr/local/mysql# ls -al

total 200

drwxr-sr-x 14 root mysql 4096 2011-04-02 18:47 .

drwxrwsr-x 14 root staff 4096 2010-10-23 13:49 ..

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 bin

-rw-r--r-- 1 root mysql 17987 2011-03-09 07:11 COPYING

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 19:38 data

drwxr-xr-x 2 root mysql 4096 2011-04-02 18:47 docs

drwxr-sr-x 3 root mysql 4096 2011-04-02 18:47 include

-rw-r--r-- 1 root mysql 7370 2011-03-09 07:11 INSTALL-BINARY

drwxr-sr-x 4 root mysql 4096 2011-04-02 18:47 lib

drwxr-sr-x 2 root mysql 4096 2010-10-22 11:52 libexec

drwxr-sr-x 4 root mysql 4096 2011-04-02 18:47 man

drwxr-xr-x 10 root mysql 4096 2011-04-02 18:47 mysql-test

-rw-r--r-- 1 root mysql 114014 2011-03-09 07:11 README

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 scripts

drwxr-sr-x 29 root mysql 4096 2011-04-02 18:47 share

drwxr-sr-x 5 root mysql 4096 2011-04-02 18:47 sql-bench

drwxr-sr-x 2 root mysql 4096 2011-04-02 18:47 support-files

okako:/usr/local/mysql# chown -R mysql .

okako:/usr/local/mysql# chgrp -R mysql .

okako:/usr/local/mysql# ls -al

total 200

drwxr-sr-x 14 mysql mysql 4096 2011-04-02 18:47 .

drwxrwsr-x 14 root staff 4096 2010-10-23 13:49 ..

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 bin

-rw-r--r-- 1 mysql mysql 17987 2011-03-09 07:11 COPYING

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 19:38 data

drwxr-xr-x 2 mysql mysql 4096 2011-04-02 18:47 docs

drwxr-sr-x 3 mysql mysql 4096 2011-04-02 18:47 include

-rw-r--r-- 1 mysql mysql 7370 2011-03-09 07:11 INSTALL-BINARY

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 lib

drwxr-sr-x 2 mysql mysql 4096 2010-10-22 11:52 libexec

drwxr-sr-x 4 mysql mysql 4096 2011-04-02 18:47 man

drwxr-xr-x 10 mysql mysql 4096 2011-04-02 18:47 mysql-test

-rw-r--r-- 1 mysql mysql 114014 2011-03-09 07:11 README

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 scripts

drwxr-sr-x 29 mysql mysql 4096 2011-04-02 18:47 share

drwxr-sr-x 5 mysql mysql 4096 2011-04-02 18:47 sql-bench

drwxr-sr-x 2 mysql mysql 4096 2011-04-02 18:47 support-files

okako:/usr/local/mysql# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

Installing MySQL system tables...

110402 19:40:25 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'

110402 19:40:25 [ERROR] /usr/local/mysql//libexec/mysqld: unknown option '--skip-bdb'

110402 19:40:25 [ERROR] Aborting

110402 19:40:25 [Note]

Installation of system tables failed! Examine the logs in

/usr/local/mysql/data/ for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/mysql//libexec/mysqld --skip-grant &

and use the command line tool /usr/local/mysql//bin/mysql

to connect to the mysql database and look at the grant tables:

shell> /usr/local/mysql//bin/mysql -u root mysql

mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log

gives you a log in /usr/local/mysql/data/ that may be helpful.

Please consult the MySQL manual section

'Problems running mysql_install_db', and the manual section that

describes problems on your OS. Another information source are the

MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if

you do mail us, you MUST use the /usr/local/mysql//scripts/mysqlbug script!

okako:/usr/local/mysql# ls -al libexec/

total 8744

drwxr-sr-x 2 mysql mysql 4096 2010-10-22 11:52 .

drwxr-sr-x 16 mysql mysql 4096 2011-04-02 19:42 ..

-rwxr-xr-x 1 mysql mysql 7791653 2010-10-22 11:52 mysqld

-rwxr-xr-x 1 mysql mysql 1134365 2010-10-22 11:52 mysqlmanager

okako:/usr/local/mysql# exit

exit

okkaba@okako:~/mysql/mysql-5.5.10$ /usr/local/mysql/libexec/mysqld --skip-grant &

[1] 26361

okkaba@okako:~/mysql/mysql-5.5.10$ 110402 19:47:31 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'

110402 19:47:31 [Warning] Can't create test file /var/lib/mysql/okako.lower-test

110402 19:47:31 [Warning] Can't create test file /var/lib/mysql/okako.lower-test

/usr/local/mysql/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)

110402 19:47:31 [ERROR] Aborting

110402 19:47:31 [Note]

[1]+ Exit 1 /usr/local/mysql/libexec/mysqld --skip-grant

okkaba@okako:~/mysql/mysql-5.5.10$ /usr/local/mysql/libexec/mysqld --skip-grant &

[1] 26363

okkaba@okako:~/mysql/mysql-5.5.10$ 110402 19:48:01 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'

110402 19:48:01 [Warning] Can't create test file /var/lib/mysql/okako.lower-test

110402 19:48:01 [Warning] Can't create test file /var/lib/mysql/okako.lower-test

/usr/local/mysql/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)

110402 19:48:01 [ERROR] Aborting

110402 19:48:01 [Note]