max connections

04/23/2011 17:42 'oShet#1
Hi, ich habe das hier gemacht

Code:
At first stop your Server and MySQL
# /usr/local/etc/rc.d/mysql-server stop
Then go into the Order /etc
And make there a new data with the name my.cnf and put that in it
[QUOTE][mysqld] 
local-infile=0 
skip-locking 
query_cache_limit=32M 
query_cache_size=32M 
query_cache_type=1 
max_connections=99999999 
interactive_timeout=100 
wait_timeout=100 
connect_timeout=20 
thread_cache_size=128 
key_buffer=16M 
join_buffer=1M 
max_allowed_packet=16M 
table_cache=1024 
record_buffer=1M 
sort_buffer_size=2M 
read_buffer_size=2M 
max_connect_errors=99999 
# Try number of CPU's*2 for thread_concurrency 
thread_concurrency=2 
myisam_sort_buffer_size=64M 
server-id=1 
bind-address=0.0.0.0 

[safe_mysqld] 
err-log=/var/log/mysqld.log 
open_files_limit=8192 

[mysqldump] 
quick 
max_allowed_packet=16M 

[mysql] 
no-auto-rehash 
#safe-updates 

[isamchk] 
key_buffer=64M 
sort_buffer=64M 
read_buffer=16M 
write_buffer=16M 

[myisamchk] 
key_buffer=64M 
sort_buffer=64M 
read_buffer=16M 
write_buffer=16M 

[mysqlhotcopy] 
interactive-timeout  [/QUOTE]

Give the file the rights of 777
and then Reboot the server and its all in all ok
Sorry for my bad englisch
Aber jetzt gibt es alle 2-3 Minuten kicks aufm Server.
Hab schon max connection auf 1000 geändert, bringt auch nix. Immer kicks.

Wenn ich per command ändern will dann bekomm ich diese fehlermeldung:
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
05/19/2011 20:16 'oShet#2
up.. 23.04
jetzt 19.05..