MySql Replication problem!

[fakhir_iqbal]

Hi,
I am trying to setup the replication in mysql, I have done all the things which is described in mysql replication documentation.
I have created the user 'repl' and given him super and replication privileges but when I try the command :

"change master to master_host='host_name'master_user='repl',master_password='password'"

then I get error "Access denied, you need super privilege for this

operation" and when I type "Start Slave;" command it gives error "Access

denied for user @ <using password No>".

Can you please help me why it's occuring and how can i resolve it.

Thanx in advance.

Regards,

Fakhir.

[mhalloran]

Have you added a user on the master server with access to the database that you want replicated? For example, if the ip address of the slave server is 123.123.123.123, a user has to exist on the master server that allows access from that IP address.

You could just add a user name called rep_user:

GRANT ALL
ON db_name.*
TO rep_user@123.123.123.123
IDENTIFIED BY 'password'

Then connect with to the master server with those details.

also, make sure both users have replications privileges:

http://dev.mysql.com/doc/mysql/en/GRANT.html

Here's a great tutorial:
http://egov.sec.state.ri.us/howto/mysql_replication/view

[Mucello]

Also-- after you add the correct permissions, restart the service mysqld just to make sure the new user privileges get loaded.

[ultraslacker]

Just do flush privileges, no need to restart.