Sponsored Content
Operating Systems Linux SuSE PhPMyAdmin basic set up on SUSE linux 9.1 Post 78212 by sybella1 on Sunday 17th of July 2005 05:10:06 PM
Old 07-17-2005
Quote the output of "mysqld --help", the section showing the variables. In particular, I would like to see the values for "datadir", "log", "log-error" and "socket". If possible, quote the entire section. It may help locate where your log files are kept.[/QUOTE]

The entire section of "mysqld --help" is as follows:

basedir /usr/
sync-frm TRUE
bind-address (No default value)
console FALSE
chroot (No default value)
character-sets-dir /usr/share/mysql/charsets/
datadir /var/lib/mysql/
default-character-set latin1
enable-locking FALSE
enable-pstack FALSE
gdb FALSE
init-file (No default value)
log (No default value)
language /usr/share/mysql/english/
local-infile TRUE
log-bin (No default value)
log-bin-index (No default value)
log-isam myisam.log
log-update (No default value)
log-slow-queries (No default value)
log-slave-updates FALSE
low-priority-updates FALSE
master-host (No default value)
master-user test
master-port 3306
master-connect-retry 60
master-retry-count 86400
master-info-file master.info
master-ssl FALSE
master-ssl-key (No default value)
master-ssl-cert (No default value)
master-ssl-capath (No default value)
master-ssl-cipher (No default value)
myisam-recover OFF
memlock FALSE
disconnect-slave-event-count 0
abort-slave-event-count 0
max-binlog-dump-events 0
sporadic-binlog-dump-fail FALSE
new FALSE
old-protocol 10
pid-file /var/lib/mysql/linux.pid
log-error
port 3306
report-host (No default value)
report-user (No default value)
report-password (No default value)
report-port 3306
rpl-recovery-rank 0
relay-log (No default value)
relay-log-index (No default value)
safe-user-create FALSE
server-id 1
show-slave-auth-info FALSE
concurrent-insert TRUE
skip-grant-tables FALSE
skip-slave-start FALSE
relay-log-info-file relay-log.info
slave-load-tmpdir /tmp/
socket /var/lib/mysql/mysql.sock
sql-bin-update-same FALSE
sql-mode OFF
temp-pool TRUE
tmpdir /tmp
external-locking FALSE
use-symbolic-links TRUE
symbolic-links TRUE
log-warnings FALSE
warnings FALSE
back_log 50
binlog_cache_size 32768
connect_timeout 5
delayed_insert_timeout 300
delayed_insert_limit 100
delayed_queue_size 1000
flush_time 0
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_stopword_file (No default value)
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 16777216
long_query_time 10
lower_case_table_names 0
max_allowed_packet 1047552
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
bulk_insert_buffer_size 8388608
myisam_block_size 1024
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 2147483647
myisam_repair_threads 1
myisam_sort_buffer_size 8388608
net_buffer_length 8192
net_retry_count 10
net_read_timeout 30
net_write_timeout 60
open_files_limit 0
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_size 0
query_cache_type 1
query_prealloc_size 8192
read_buffer_size 131072
read_rnd_buffer_size 262144
record_buffer 131072
relay_log_space_limit 0
slave_compressed_protocol FALSE
slave_net_timeout 3600
range_alloc_block_size 2048
read-only FALSE
slow_launch_time 2
sort_buffer_size 524280
table_cache 64
thread_concurrency 10
thread_cache_size 0
tmp_table_size 33554432
thread_stack 196608
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
wait_timeout 28800
default-week-format 0

regards,
Sybella
 

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

1st install Suse, network config set up

Hello, I'm a newbie to unix. I just about have the Suse 10.1 installed. During set up it automatically detected components to access the internet. But failed. I lost now. Any ideas? Thank You (2 Replies)
Discussion started by: Nick7269
2 Replies

2. Cybersecurity

How to set CoreDump in SuSE 10

Hi All, Am trying to modify the coreDump value in SuSE 10 by doing the following steps : 1. Add the line "ulimit -Sc 1004" to /etc/profile 2. Relogin using telnet and try the command "ulimit -c". The value is 1004 3. Now relogin using xbrowser the ulimit value is not reflected. OS :... (1 Reply)
Discussion started by: Laksmi
1 Replies

3. Shell Programming and Scripting

How to set up Telnet on Suse?

I am trying to use telnet to access a linux box. I know I should be using SSH (which I use personally), but i have to use telnet. How do I configure the linux box to accept the telnet request. I am using Suse Thanks for any help (11 Replies)
Discussion started by: salil2012
11 Replies

4. Programming

Set password of a user in phpmyadmin

I have a mysql database on the server where I have root access also to phpmyadmin. I have such a database 1, which is a table users where a user named admin. How shall be observed as the password for this user? (1 Reply)
Discussion started by: Mumie
1 Replies
All times are GMT -4. The time now is 05:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy