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 →

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. 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 →