MySQL Secure Installation Set (Change) root password Remove anonymous users Disallow root login remotely Remove test database and access to it Reload privilege tables Start MySQL Secure Installation with following command /usr/bin/mysql_secure_installation Output: NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE […]
Mysql
RETURN TO PART-1 Installation/Configuration of Saturn (mysql slave) yum install -y mysql-server Update the following values in /etc/my.cnf server-id = 2 start the mysql server Export the db dump. cat universe.sql | mysql Configure SSH Tunneling. Here, we will use a local user account adduser sqltunel su – sqltunnel ssh-keygen […]
Mysql Replication using SSH Tunneling
Install and Configure mysql master-master or master-slave replication using ssh tunneling. SSH tunneling helps you replicate securely.