156 Oud wrote: > Hi, > > I've got a very strange problem with one of my MySQL servers. > I've got 2 dedicated servers with MySQL 4.0.21, all is fine there. > > My new server with MySQL-4.1.14 give me some headakes ! > Sometimes i've got errors like > UPDATE command denied to user 'MyUser'@'192.168.0.4' for table 'MyTable'. > But 99% of time, theses queries are OK. > MySQL privilges haven't changed since several days.
Looks just like the problem I just posted (see subject "random permission denied issues"). ;-)... For me as well, the trouble started after switching from 4.0 to 4.1 I am using the 'old style' passwords still. I forgot to post my my.cnf: [mysqld] master-host=xxxxx master-user=repl master-password=xxxxxx master-port=3306 server-id=25 set-variable=max_connections=1000 set-variable=max_allowed_packet=50M set-variable=key_buffer=100M set-variable=join_buffer_size=10M set-variable=sort_buffer=50M set-variable=record_buffer=10M set-variable=table_cache=200 set-variable=thread_concurrency=4 set-variable=long_query_time=7 set-variable=interactive_timeout=1000 set-variable=binlog_cache_size=100000 set-variable=tmp_table_size=100M set-variable=log_slow_queries=ON set-variable=wait_timeout=25000 log-bin log-warnings log-slave-updates innodb_data_home_dir=/var/lib/mysql innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:1000M:autoextend set-variable=innodb_buffer_pool_size=700M set-variable=innodb_additional_mem_pool_size=50M innodb_log_group_home_dir=/var/lib/mysql innodb_log_arch_dir=/var/lib/mysql innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=200M set-variable = innodb_log_buffer_size=10M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=60 set-variable = query_cache_limit=10M set-variable = query_cache_size=50M set-variable = query_cache_type=1 # set-variable = max_relay_log_size=100M # set-variable = relay_log_space_limit=300M set-variable = max_binlog_size=100M skip-name-resolve safe-show-database
signature.asc
Description: OpenPGP digital signature
