Hello.
See: http://dev.mysql.com/doc/mysql/en/Access_denied.html "Massimo Petrini" <[EMAIL PROTECTED]> wrote: > 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] > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
