List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:February 8 2005 11:40am
Subject:Re: ERROR 1189 (08S01): Net error reading from master
View as plain text  
Hello.

>mysql> grant replication  slave, file on  .  to repl@stripped
>identified by 'pass';
>Query OK, 0 rows affected, 1 warning (0.00 sec)

You should additionally grant SUPER, RELOAD, and SELECT privilege for
all tables that you want to load. See:
  http://dev.mysql.com/doc/mysql/en/replication-howto.html




Olivier Kaloudoff <kalou@stripped> wrote:
> [-- text/plain, encoding quoted-printable, charset: ISO-8859-1, 61 lines --]
> 
> Hi,
> 
> 
>        I have some problems here with two
> mysql servers, version 4.1.8;
> 
>        on the master server, binary logs are
> activated, free disk space is not null;
> 
> root@db0:~# ls -l /repl/mysql/data/master.*
> -rw-rw----  1 mysql mysql 1814256 2005-02-08 11:43 
> /repl/mysql/data/master.000001
> -rw-rw----  1 mysql mysql      16 2005-02-07 22:28 
> /repl/mysql/data/master.index
> 
> 
> root@db0:~# df -h /repl/mysql/data/
> Sys. de fich.         Tail. Occ.  Free. %Occ. Mont? sur
> /dev/hd0/repl0        4,0G  607M  3,4G  15%   /repl0
> 
> 
>        the correct grant has been typed on
> the master server to allow the slave to connect and
> replicate; (launched with --skip-name-resolve)
> 
> mysql> grant replication  slave, file on *.* to repl@stripped 
> identified by 'pass';
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> 
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
> 
> 
>        now I change the "master to", and ask for the master (in 
> production), to give his data to the slave;
> 
> mysql> change master to MASTER_HOST='db0', MASTER_USER='repl', 
> MASTER_PASSWORD='pass', MASTER_LOG_FILE='master.000001';
> Query OK, 0 rows affected (0.03 sec)
> 
> 
>        the only thing I can get is:
> 
> mysql> load data from master;
> ERROR 1189 (08S01): Net error reading from master
> 
> 
> 
> Any ideas ? is this a bug in 4.1.8 ?
> 
> 
> Regards,
> 
> 
> Olivier Kaloudoff
> CKR Solutions Open Source
> Mandelieu, France
> http://www.ckr-solutions.com
> 
> 
> 
> [-- text/plain, encoding 7bit, charset: us-ascii, 4 lines --]
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
ERROR 1189 (08S01): Net error reading from masterOlivier Kaloudoff8 Feb
  • Re: ERROR 1189 (08S01): Net error reading from masterGleb Paharenko8 Feb
  • Re: ERROR 1189 (08S01): Net error reading from masterOlivier Kaloudoff8 Feb
    • Re: ERROR 1189 (08S01): Net error reading from masterBastian Balthazar Bux8 Feb
      • default valuesEmmett Bishop8 Feb
        • Re: default valuesJeff Smelser8 Feb
          • Re: default valuesMichael Stassen9 Feb
      • Re: ERROR 1189 (08S01): Net error reading from masterOlivier Kaloudoff8 Feb