Mysql Replication is used to get a mirror copy of master server to slave. All changes made in server is updated on slave. This can be achieved by the following steps. one thing to be notify is the master and salvemay contain the same version of mysql.
changes in master …
Posted on December 27, 2008 by Riyesh .
Posted on December 21, 2008 by Riyesh .
Login to mysql shell and key in :
For Local users
mysql> grant all on database.* to username@’localhost’ identified by ’password’;
mysql> flush privileges;
Verify the connection by executing the command from bash prompt:
mysql -u username -p databasename
For remote users :
mysql> grant all on database.* to username@’%’ identified by ’password’;
mysql> flush privileges;
Verify the connection …











