Hi everybody, I am trying to compile/configure MySQl 5.0.41 on a Mandrake 10 linux box.
In doing so, I am getting some errors with mysql_install_db (ERROR: 1049 Unknown database 'mysql', Installation of system tables failed!) Please let me know how to solve the problem. Thanks in advance for your time and help. Anand Here are the details pertaining to my problem: I used this as a guide: http://dev.mysql.com/doc/refman/5.0/en/quick-install.html: and followed all the steps. The following error(s) comes when I try using mysql_install_db ---------------------------------------------------- /usr/local/mysql/bin/mysql_install_db --user=mysql Installing MySQL system tables... ERROR: 1049 Unknown database 'mysql' 070616 1:24:38 [ERROR] Aborting 070616 1:24:38 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /usr/local/mysql/var for more information. You can try to start the mysqld daemon with: /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/var that may be helpful. --------------------------------------------------- And then, when I do /usr/local/mysql/libexec/mysqld --skip-grant & as suggested in the above error message, it just aborts. Here is the architecture info. from mysqlbug ------------------------------------------------------ >Release: mysql-5.0.41 (Source distribution) >C compiler: gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) >C++ compiler: g++ (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) >Environment: <machine, os, target, libraries (multiple lines)> System: Linux 2.6.3-7mdk #1 Wed Mar 17 15:56:42 CET 2004 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/specs Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit --enable-clocale=gnu --enable-languages=c,c++,ada,f77,objc,java,pascal --host=i586-mandrake-linux-gnu --with-system-zlib Thread model: posix gcc version 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 13 2004 /lib/libc.so.6 -> libc-2.3.3.so -rwxr-xr-x 1 root root 1281788 Feb 16 2004 /lib/libc-2.3.3.so -rw-r--r-- 1 root root 204 Feb 16 2004 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--with-unix\ -socket-path=/usr/local/mysql/tmp/mysql.sock' ------------------------------------------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
