I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs correctly (it is a slave member of my domain). But if I try to connect from a remote client with mysql administrator, I receive this error: Could not connect to the specified instance Mysql error number 1130 Host "name" is not allowed to connect tothis MYSQL sever
The ping result correct. Which is my configuration error ? (see my.ini below) Thanks Massimo ---------------------------------------------------------------------------- ---------- # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable=key_buffer=16K set-variable=max_allowed_packet=16M set-variable=thread_stack=64K set-variable=table_cache=4 set-variable=sort_buffer=1024K set-variable=net_buffer_length=2K #PARTE PER REPLICA server-id=33 master-host=SEURAT report-host=SEURAT master-user=root replicate-wild-ignore-table=OMTWRK.WRK_% replicate-wild-ignore-table=omtwrk.wrk_% set-variable=slave-net-timeout=172800 #skip-slave-start # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir=C:\mysql\ #datadir=C:\AnnaNoBck\DATI\MySQL\data\ datadir=D:\mysql\Data\ log-error=d:\mysql\data\mysql.err # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using Innobase tables innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog innodb_data_home_dir=D:\mysql\InnoDB innodb_log_group_home_dir=D:\mysql\InnoDB\InnoLog innodb_log_arch_dir=D:\mysql\InnoDB\InnoLog set-variable=innodb_mirrored_log_groups=1 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable=innodb_buffer_pool_size=16M set-variable=innodb_additional_mem_pool_size=16M set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 default-table-type=innodb [mysqldump] quick set-variable=max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [myisamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe --------------------------------------------------------- Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel. +39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
