Hello.
MySQL could be installed under unprivileged user in location owned by that user. You should correctly specify the parameters in the configuration file or in command line. I usually launch mysqld using mysqld_safe with --defaults-file command line option. Here's an example of such file: port = 3726 socket = /home/gleb/mysqls/tmp/mysql.sock.gleb.l default_character_set=cp1251 character-sets-dir= /home/gleb/mysqls/mysql-debug-5.0.4-beta-pc-linux-gnu-i686/share/mys ql/charsets [mysqld] max_connections=3 log-long-format default_character_set=cp1251 default-collation=cp1251_bin log_slow_queries=/home/gleb/mysqls/logs/mysql.log-slow.l long_query_time=1 myisam_data_pointer_size=4 log_warnings=2 set-variable=user=gleb port = 3726 socket = /home/gleb/mysqls/tmp/mysql.sock.gleb.l skip-locking pid-file = /home/gleb/mysqls/tmp/mysql.pid.gleb.l log = /home/gleb/mysqls/logs/mysql.log.l log-bin = /home/gleb/mysqls/logs/log_l/log_l log-error = /home/gleb/mysqls/logs/mysql.log-error.l datadir =/home/gleb/mysqls/mysql-debug-5.0.4-beta-pc-linux-gnu-i686/data key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K wait_timeout=1000 interactive_timeout=50 server-id = 1 innodb_data_home_dir=/home/gleb/mysqls/mysql-debug-5.0.4-beta-pc-linux-gnu-i686/data innodb_data_file_path = ibdata1:10M;ibdata2:50M:autoextend innodb_log_group_home_dir =/home/gleb/mysqls/mysql-debug-5.0.4-beta-pc-linux-gnu-i686/da ta innodb_log_arch_dir =/home/gleb/mysqls/mysql-debug-5.0.4-beta-pc-linux-gnu-i686/data innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M default_character_set = latin1 [mysql] no-auto-rehash [isamchk] key_buffer = 8M sort_buffer_size = 8M [myisamchk] key_buffer = 8M sort_buffer_size = 8M character-sets-dir=/home/gleb/mysqls/mysql-debug-5.0.4-beta-pc-linux-gnu-i686/share/mysq l/charsets "qin lei" <[EMAIL PROTECTED]> wrote: > I downloaded the binary files and upziped them to /home/myname/mysql.(I use > red hat linux) when I use command "mysqld --console" to run the server. The > following message are showed on the screen: > > [EMAIL PROTECTED] bin]$ ./mysqld --console > 050525 17:36:11 Warning: Can't create test file > /var/lib/mysql/pc-lg41-4.lower-t > est > 050525 17:36:11 Can't find messagefile > '/usr/local/mysql/share/mysql/english/err > msg.sys' > 050525 17:36:11 Aborting > > I think the problem is I don't have enough priviledge. Is there any way to > install it without root priviledge? > > _________________________________________________________________ > $$$$$$$$$$$$$$ MSN Messenger: http://messenger.msn.com/cn > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
