if you have ConfigServer Security & Firewall enabled in WHM , only a certain ports are allowed to come in/out. By default mysql will be blocked, to unblock it you need to add 3306 as an allowed list Go to ConfigServer Security & Firewall – > Firewall Configuration -> Add 3306 into TCP_IN list ( separated by comma) like this: 20,21,22,25,53,80,110,143,443,465,587,993,995,2077,2078,2082,2083,2086,2087,2095,2096,3306Read More →

1. If this is an existing users Syntax: usermod -a -G groupname username For example: usermod -a -G sudo myadminaccount -> this will make myadminaccount belong to sudo group , this mean it can run sudo su – to becom a root. 2. For new user ( you haven’t created it yet) Syntax: useradd -G groupname username This will add a new username to a group name groupnameRead More →

Do you have this problem ? – you made the changes in /etc/ha.d/ldirectord.cf , – restart ipvsadm : /etc/init.d/ipvsadm restart you see the changes : ipvsadm -L But after sometimes, you go back and check , the weight has been changed ? WHY ? It’s because there are 2 ldirectord ar running ( you can verify by running top command Kill one of them and check the status (ipvsadm -L) it will fix your problemRead More →

If you cant not login to gmail via your outlook , and you got a message asking you to visit https://support.google.com/mail/bin/answer.py?hl=en&answer=78754 This means your account maybe blocked, you can follow these steps to fix it – login to your gmail via webmail if you see any captcha ,enter it and login to webmail if this step does t fix your problem , go to your Account Settings and change to a new password Hope it helpRead More →

Sometimes, you want to remove the replication , it could be because the replication no longer works, or you don’t want to replicate. Here are some commands that you can use Login to mysql: mysql -uroot -p Enter your mysql root password Run the following command to disable the replication with master. STOP SLAVE; RESET SLAVE; change master to master_host=”, master_user=”, master_password=”; On the master, if you want to disable the replication you should login to mysql and run : stop master Delete all .bin file in /var/log/mysql Edit /etc/my.inf and remove the replication sectionRead More →

There are various method to setup multiple of mysql instances on a single linux ubuntu server. In this scope of this page, i will show you the most simple one. You can follow the steps below to get it done: 1. Create separate data and log directories We need to create new directories for our datadir and log folder (if used). Also we need to assign proper permissions on those folders: mkdir /var/lib/mysql2 chown -R mysql.mysql /var/lib/mysql2/ mkdir /var/log/mysql2 chown -R mysql.mysql /var/log/mysql2 2. Create a new mysql configuration file Next we need a separate configuration file. We can start by copying the existing one andRead More →