fix erorr

[king_of_shadows]

Hi! Good time

Mysql server logs me

2014-12-17 1338 0 [Warning] option 'thread_cache_size': unsigned value 1048576 adjusted to 16384


2014-12-17 1338 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp se$


2014-12-17 1338 26184 [Warning] Buffered warning: option 'table_open_cache': unsigned value 5242880 adjusted to 524288


2014-12-17 1338 26184 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 1048737)


2014-12-17 1338 26184 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 524288)

Config file

[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 = 128M
query_cache_type=1
query_cache_limit= 64M
key_buffer_size = 128M
max_allowed_packet = 2M
table_open_cache = 5M
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 32M
thread_cache_size = 1M




tmp_table_size = 64M
max_heap_table_size = 64M


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 = 128M
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 = 128M
sort_buffer_size = 128M
read_buffer = 4M
write_buffer = 4M


[mysqlhotcopy]
interactive-timeout

Please help me to solve this problem

 

[nobaloney]

Your problem is a warning only; mysql is adjusting an unsigned integer to a signed one. Are you using DirectAdmin? These forums are for DirectAdmin users only, and you likely won't get help from us here if you're not using DirectAdmin, because we won't know enough about your configuration.

If you're using DirectAdmin with a default installation of MySQL then please reply letting us know the DirectAdmin version you're using and your OS Distribution.

Jeff