After I created the mysql database, the 'show tables' command displayed the empty set. I checked my mysql.log file and found no errors. My permission in mysql.db and mysql.user look good (i.e., usernames seem to be correct and all permission columns are 'Y'). Any help would be greatly appreciated.
Following is my my.cnf file: [mysqld] datadir=/var/lib/jlhmysql socket=/tmp/jlhmysql.sock innodb_data_file_path = u02/ibdata/ibdata1:2000M innodb_data_home_dir = / set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /u06/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = /u06/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=350M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/jlhmysqld.log pid-file=/var/run/mysqld/jlhmysqld.pid I configured mysql with the following commands: export CFLAGS="-O3 -mpentiumpro" export CXX=gcc export CXXFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/jlhmysql --enable-assembler --with-mysqld-ld flags=-all-static --disable-shared --with-extra-charset=complex --with-innodb Jeff Holt Hotsos Enterprises, Ltd. [EMAIL PROTECTED] +1.817.821.9553 tel +1.413.480.7346 fax http://www.hotsos.com Join the Oracle Performance Revolution! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
