این متن رو در فایل my.cnf جایگزین کنید بعدش mysql رو ریستارت بدید
کد:[client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking bind-address = 0.0.0.0 federated query_cache_size = 1024M query_cache_type=1 query_cache_limit= 256M key_buffer_size = 512M max_allowed_packet = 128M table_open_cache = 128M sort_buffer_size = 128M read_buffer_size = 128M read_rnd_buffer_size = 128M myisam_sort_buffer_size = 32M thread_cache_size = 5M tmp_table_size = 128M max_heap_table_size = 128M innodb_data_home_dir = /var/lib/mysql innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql innodb_buffer_pool_size = 256M innodb_log_file_size = 32M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar withSQL # safe-updates [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 4M write_buffer = 4M [mysqlhotcopy] interactive-timeout






پاسخ با نقل قول