admin Recently, I had to find a connection script for mysql as the clients programmer had gone away. I knew the database username and here is the grep command that found it. * Where database username is the actulay database username in the plesk database
To change the root password for your Dedicated Server: Log into WHM. Click the Server Configuration icon on the home screen. From the Server Configuration menu, click Change Root Password. In the New Password field, enter the desired new password. In the Confirm New Password field, retype the new password.
Before you begin installing the signature, you will need to see the hidden files and file extensions. Go to your File Explorer (Windows key + E) Select your hard drive (C:/ for most users) Click on the Organize drop-down box Click on the Folder and Search options tab In the folder options, select the View … Read more
edit /etc/my.cnf to show the following… Where, * bind-address : local IP address to bind to. If you wish mysql listen on all IPs, don’t use this option. * skip-networking : Don’t listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recommended for systems … Read more
nano /var/lib/mysql/server.com.err There are two solutions to this particular problem: 1. Restore the my.cnf file to its original state, with an innodb_log_file_size equal to the actual size of the existing InnoDB log files. 2. Rename or move both the ./ib_logfile0 and ./ib_logfile1 files, and then start the MySQL server. The ./ib_logfile0 and ./ib_logfile1 files are … Read more
Can I run a Windows 2008 R@ server and a VM? MS just updated their Usage rights and they are allowing 1 Physical OS + 1 VM with Standard R2. Here is the link to their official site for VM licensing. http://www.microsoft.com/licensing/about-licensing/virtualization.aspx
There are two files that matter: Also, if present: Windows Plesk files are in similar locations — C:\inetpub\vhosts\ instead of /var/www/vhosts Edit index.html after backing up.
nginx: [emerg] bind() to 68.168.98.181:443 failed (99: Cannot assign requested address) nginx: configuration file /etc/nginx/nginx.conf test failed You can disable nginx which should force the configuration to rebuild: /usr/local/psa/admin/bin/nginxmgr -d You can also try the steps below: http://kb.sp.parallels.com/en/114245 If you get the error: Apache config (14180811290.93120100) generation failed: Template_Exception: nginx: [emerg] bind() to 68.168.98.181:80 failed … Read more
Check the header of an email You can also add Barracuda RBL to Exim in WHM For cPanel /home/username/.spamassassin/user_prefs as described: Other Resources: http://www.toao.net/566-improving-spamassassin-accuracy-with-statistics
The file mysql-bin.index keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: PURGE BINARY LOGS TO ‘binlogname’; PURGE BINARY LOGS BEFORE ‘datetimestamp’; These will clear all binary logs before the binlog or timestamp you just specified. For example, if you … Read more