To find the my.conf file location use the following command:
Enable the firewall within Plesk then add the needed rules to Windows Firewall (set the IP’s can connect on tcp/1433). Plesk does not have the ability to set the IP’s or IP range. Resources http://www.rackspace.com/knowledge_center/article/configuring-ms-sql-server-for-remote-access http://www.rackspace.com/knowledge_center/article/creating-an-inbound-custom-allow-rule-for-windows-firewall-windows-2008
Go to cpanel > cron jobs > standard. At the top is an email field Change to an alternate email Or FThe way to change the email account WHMCS sends the daily cron reports to… 1. Log in to WHMCS. 2. Click on Configuration -> Administrators. 3. Click on the little edit-button for the full … Read more
There are 2 different limits for MYSQL. Max Connections and Max user connections. By default, the limit is 151 for max connections and 0 or unlimited for user connections. MySQL server has a default limit of 151 simultaneous connections. Most connections to the SQL server run very quickly so even a large amount of queries … Read more
How to reset the mysql password on a linux server. CentOS First, stop the MySQL service/daemon. On Centos/RHEL you would run: Next, edit the MySQL config file (/etc/my.cnf on CentOS/RHEL) and add the following to the [mysqld] section. Start MySQL back up You will now be able to connect as user root without any password. … Read more
If the exim mail queue is filled with spam, you can remove the email as follows: Clearing mail queue by running the following command: http://www.cyberciti.biz/faq/exim-remove-all-messages-from-the-mail-queue/
The screen program is a powerful terminal multiplexer for Unix-like operating systems such as Linux. It allows you to create multiple virtual terminals within a single terminal window or remote session, which can be detached and reattached as needed, even if the original terminal session is disconnected.
Normally, checking mail may produce an SSL error for plesk mail services. All clients Outlook, Mac mail, thunderbird, show a a message for ssl certificate. How to fix it. You would need to purchase a SSL certificate for your servers hostname and set it up so it gets used for the mail service on the … Read more
if you don’t specify the socket path, php 5.5 will use /tmp/mysql.sock. Update my.cnf to: pdo_mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
Install tcpdump List Network Interfaces Output Capture packets from a particular ethernet interface using You can use the -v option to increase the verbosity of the output, or -vv and -vvv to increase it even further. If you don’t want tcpdump to endlessly output data to your terminal, you can use the -c option to … Read more