Ad Ad Ad Ad

MySql Replication

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 …

Grant privileges to Local & Remote MySQL Users

 
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 …