I compiled and installed mysql-max-3.23.51. Installation process seems to go fine.
When I go to run mysql_install_db however, I get the following error : ERROR : 1064 use mysql; syntax error I try starting mysqld without grant tables - and I can. However, when I connect via a client, none of the sql commands are accepted. It simply says ERROR : 1064 : Syntax error. The only thing I can do is use mysql; If I try to CREATE DATABASE name; I get ERROR : 1064 : Syntax error at "DATABASE name"; I am getting really frustrated. Can someone help me. Attached is my.cnf that I am using . # Example mysql config file for small systems. # # This is for a system with little memory (<= 64M) where MySQL is only used # from time to time and it's important that the mysqld deamon # doesn't use much resources. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/sendmail/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/slms/slms-mysql/slms-mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/slms/slms-mysql/slms-mysql/mysql.sock skip-locking set-variable = max_connections=50 set-variable = key_buffer=51M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=2048K set-variable = record_buffer=2048K set-variable = net_buffer_length=16K set-variable = myisam_sort_buffer_size=32M # Try number of CPU's*2 for thread_concurrency set-variable = thread_stack=128K set-variable = thread_cache_size=16 set-variable = thread_concurrency=2 log-bin server-id = 1 # Uncomment the following if you are using Innobase tables innodb_data_home_dir = innodb_data_file_path = /var/slms/slms-mysql/slms-mysql/ibdata/ibdata1:100M:autoextend innodb_log_group_home_dir = /var/slms/slms-mysql/slms-mysql/ibdata innodb_log_arch_dir = /var/slms/slms-mysql/slms-mysql/ibdata set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=76M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit = 1 innodb_log_archive = 0 set-variable = innodb_buffer_pool_size=512M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=32M set-variable = sort_buffer=32M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=32M set-variable = sort_buffer=32M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout Here are the config args CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 \ -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ./configure \ --prefix=/usr/local/sendmail/slms-mysql-1.0/mysql \ --localstatedir=/var/slms/slms-mysql \ --with-unix-socket-path=/var/slms/slms-mysql-1.0/mysql.sock \ --enable-local-infile \ --enable-assembler \ --disable-shared \ --with-extra-charsets=complex \ --with-server-suffix=-max \ --with-innodb \ --enable-thread-safe-client \ --with-named-curses-libs=-lcurses --program-prefix=-max' --------------------------------------------------------------------- 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
