Hello.
>mysql> grant replication slave, file on . to [EMAIL PROTECTED] >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 <[EMAIL PROTECTED]> 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; > > [EMAIL PROTECTED]:~# 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 > > > [EMAIL PROTECTED]:~# 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 [EMAIL PROTECTED] > 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 / /|_/ / // /\ \/ /_/ / /__ [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]
