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
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