Hello.
>Error: 'Unknown MySQL server host > 'server5.domain.com' (1)' errno: 2005 Does the problem remain if you remove the following line from the my.cnf on the server8: skip-networking "Chris Mason" <[EMAIL PROTECTED]> wrote: > I have two servers, server5.mydomain.com and server8.mydomain.com. I = > want to > replicate one database on server5 to server 8. > I did the whole proceedure as recommended in > http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to = > Set > Up Replication > > I setup the GRANT statement on server5 for the slave. > > mysql> SHOW GRANTS FOR [EMAIL PROTECTED]; > +------------------------------------------------------------------------= > --- > -------------------------------------------+ > | Grants for [EMAIL PROTECTED] > | > +------------------------------------------------------------------------= > --- > -------------------------------------------+ > | GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO = > 'server8'@'MyServer8IP' > IDENTIFIED BY PASSWORD 'xxxxxxx' | > +------------------------------------------------------------------------= > --- > -------------------------------------------+ > 1 row in set (0.00 sec) > > But when I stop and start the slave, I get: > > 050316 8:56:42 [Note] Slave SQL thread initialized, starting = > replication in > log 'mysql-bin.000004' at position 79, relay log > './server8-relay-bin.000001' position: 4 > 050316 8:56:42 [ERROR] Slave I/O thread: error connecting to master > '[EMAIL PROTECTED]:3306': Error: 'Unknown MySQL server host > 'server5.domain.com' (1)' errno: 2005 retry-time: 60 retries: 86400 > > When I try from the command line, I get it to work without problem: > > [EMAIL PROTECTED] mysql]# mysql -h server5.domain.com -u server8 -pxxxxxxxx > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 30 to server version: 4.1.10-standard-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql>=20 > > > > Both /etc/my.cnf files are listed below > > [EMAIL PROTECTED] mysql]# cat /etc/my.cnf=20 > [mysqld] > datadir=3D/var/lib/mysql > socket=3D/var/lib/mysql/mysql.sock > old_passwords > skip-locking > key_buffer =3D 256M > max_allowed_packet =3D 1M > table_cache =3D 256 > sort_buffer_size =3D 1M > read_buffer_size =3D 1M > read_rnd_buffer_size =3D 4M > myisam_sort_buffer_size =3D 64M > thread_cache =3D 8 > query_cache_size=3D 16M > skip-networking > sort_buffer=3D2M > log-bin > server-id=3D2 > log-slave-updates=20 > log-warnings=20 > replicate-ignore-db=3Dmysql > > replicate-do-db=3Danguillaguide > > [isamchk] > key_buffer =3D 128M > sort_buffer_size =3D 128M > read_buffer =3D 2M > write_buffer =3D 2M > > [myisamchk] > key_buffer =3D 128M > sort_buffer_size =3D 128M > read_buffer =3D 2M > write_buffer =3D 2M > > [mysqlhotcopy] > interactive-timeout > =20 > [mysql.server] > user=3Dmysql > basedir=3D/var/lib > > [safe_mysqld] > err-log=3D/var/log/mysqld.log > pid-file=3D/var/run/mysqld/mysqld.pid > > [EMAIL PROTECTED] mysql]# cat /etc/my.cnf=20 > [mysqld] > old-passwords > max_connections =3D 500 > key_buffer =3D 16M > myisam_sort_buffer_size =3D 64M > join_buffer_size =3D 2M > read_buffer_size =3D 2M > sort_buffer_size =3D 3M > table_cache =3D 1500 > thread_cache_size =3D 128 > wait_timeout =3D 14400 > connect_timeout =3D 10 > max_allowed_packet =3D 16M > max_connect_errors =3D 10 > query_cache_limit =3D 1M > query_cache_size =3D 32M > query_cache_type =3D 1 > skip-innodb > log-bin=3Dmysql-bin > server-id=3D1 > > [mysqld_safe] > open_files_limit =3D 8192 > > [mysqldump] > quick > max_allowed_packet =3D 16M > > [myisamchk] > key_buffer =3D 64M > sort_buffer =3D 64M > read_buffer =3D 16M > write_buffer =3D 16M > > Chris Mason > Anguilla > > =20 > > --=20 > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005 > =20 > > -- 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]
