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
