Support for MySQL, Sendmail,Unix,Windows and more

Installing MalwareBytes from the command line can be accomplished by doing the following:

Change to the directory where you downloaded MalWareBytes

Run the following command:

mbam-setup.exe /SP- /SILENT /NOCANCEL

For more information or Support for MalwareBytes call us at 410-838-5100 or email us at experts@expertsinwindows.com

mbam.exe /parameter
(where parameter is one of the following)

/debug: allows you to collect information to send as a bug report.
/developer: this command line parameter is explained in the false positives section.
/minimized: allows you to start the program minimized.
/quickscan: allows you to run a quick scan.
/quickscanterminate: allows you to run a quick scan. Program terminates if no items found.
/fullscan: allows you to run a full scan.
/fullscanterminate: allows you to run a full scan. Program terminates if no items found.
/runupdate: allows you to update the program without displaying result dialogs.
/register: allows you to register the program without displaying main dialog.
/fullauto: allows you to run a full scan silently.

Example: mbam.exe /register 12345 AAAA-BBBB-CCCC-DDDD

/updateshowdialog: allows you to update the program displaying all dialogs.
/schedule : allows you to schedule an update and scan for a specific hour. Scan will happen 5 minutes after update.

Example: mbam.exe /schedule 0 (will schedule for 12:00 AM local time)
Example: mbam.exe /schedule 5 (will schedule for 5:00 AM local time)
Example: mbam.exe /schedule 23 (will schedule for 11:00 PM local time)

/updateshowdialog: allows you to update the program displaying all dialogs.

Example: mbam.exe /quickscan

For more information or support call us at 410-838-5100

Do you need to convert video formats to flv? Download the following converter from dvdvideosoft.com.

PTS Tuneup now includes disk cleanup. The MyPTSMail tuneup utility now includes disk cleanup which will remove temporary files and files that are now longer needed such as setup files.

For more information on PTStuneup call us at 410-838-5100 or email us at support@scanmail-software.com.

Download the utilities at PTSMailtunep.

1.

Open Disk Cleanup by clicking the Start button Picture of the Start button, clicking All Programs, clicking Accessories, clicking System Tools, and then clicking Disk Cleanup.
2.

In the Disk Cleanup Options dialog box, choose whether you want to clean up your own files only or all of the files on the computer. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
3.

If the Disk Cleanup: Drive Selection dialog box appears, select the hard disk drive that you want to clean up, and then click OK.
4.

Click the Disk Cleanup tab, and then select the check boxes for the files you want to delete.
5.

When you finish selecting the files you want to delete, click OK, and then click Delete files to confirm the operation. Disk Cleanup proceeds to remove all unnecessary files from your computer.

The More Options tab is available when you choose to clean files from all users on the computer. This tab includes two additional ways to free even more disk space:

*

Programs and Features. Opens Programs and Features in Control Panel, where you can uninstall programs that you no longer use. The Size column in Programs and Features shows how much disk space each program uses.
*

System Restore and Shadow Copies. Prompts you to delete all but the most recent restore point on the disk.

System Restore uses restore points to return your system files to an earlier point in time. If your computer is running normally, you can save disk space by deleting the earlier restore points.

In some editions of Windows Vista, restore points can include previous versions of files, known as shadow copies, and backup images created with Windows Complete PC Backup. This information will also be deleted. For more information about System Restore, search Windows Help and Support for “system restore.

For more information or technical support by phone call 40-838-5100.

Setting a root password for MySQL on Windows

1. Start your command line by going to the Start Menu > Run and typing cmd (or type command if you are using an older version of windows)
2. Change directory to where you installed mysql to:
C:\> cd C:\mysql\bin
3. Switch to mysql command line:
C:\mysql\bin> mysql -u root mysql
4. Then set a default password:
mysql> SET PASSWORD FOR root@localhost=PASSWORD(‘mypassword’);
where “mypassword” is the password you want to use

Adding more users

1. Start your command line by going to the Start Menu > Run and typing cmd (or type command if you are using an older version of windows)
2. Change directory to where you installed mysql to:
C:\> cd C:\mysql\bin
3. Switch to mysql command line (if you have not set a root password remove the -p switch when you type it in):
C:\mysql\bin> mysql -u root -p mysql
4. Then then add your new user:
mysql> GRANT ALL PRIVILEGES ON *.* TO newuserl@localhost IDENTIFIED BY ‘newpasswordr’;
where “newuserl” is the username and “newuserr” is the password you want to use. You can also limit users to specific database, allow only certain remote hosts to connect all using the GRANT statement. However, that is outside the scope of this tutorial so search for more info on using GRANT if you are interested in those features.

For more information or technical support by phone for MySQL call us at 410-838-5100 or email us at experts@expertsinwindows.com

PTS is a software development and consulting company dedicated to finding ways to assist you with your IT issues. PTS delivers to it’s customers quality expertise, software and internet services solutions at unbeatable prices. Specializing in email systems and Unix, networking, as well as all versions of Windows including Windows Server PTS has the expertise needed to create customized software for any type of business. Support is available on a monthly,3 months,6 months or yearly basis, as well as more comprehensive support contracts including 24/7 coverage We can help you with MYSQL, Windows servers and clients, Unix, Networking, Perl programming,PHP, C programming and more. Whether it is a short or long range project we can provide the support and expertise you need. For more info about what PTS can offer you call us at 410-838-5100 or email us support@scanmail-software.com.

Definition and Usage

The substr() function returns a part of a string.
Syntax
substr(string,start,length)

Parameter Description
string Required. Specifies the string to return a part of
start Required. Specifies where to start in the string

A positive number – Start at a specified position in the string
A negative number – Start at a specified position from the end of the string
0 – Start at the first character in string

length Optional. Specifies the length of the returned string. Default is to the end of the string.

A positive number – The length to be returned from the start parameter
Negative number – The length to be returned from the end of the string

Tips and Notes

Note: If start is a negative number and length is less than or equal to start, length becomes 0.
Example 1

echo substr(“Hello world!”,6);

The output of the code above will be:
world!

Example 2

echo substr(“Hello world!”,6,5);

The output of the code above will be:
world

For more information or technical support by phone for PHP call us at 410-838-5100 or email us at experts@expertsinunix.com

Do you need support for short or long term projects? Do you need a tech to look at your server or workstation? Call PTS. Our techs can help you with coding projects, down systems, software installation and more. Support by the month, three months, six months and yearly are available. These include full phone support and remote assistance.  Do you have questions about MySQL, PHP, Windows Server?  Call and talk to tech. Do you just have a question? You have a tech available to help you. You have full access to our PTS Utilities which can give daily status reports emailed to you from your workstations making it easier to monitor your workstations or server. For more information call us at 410-838-5100 or email us at support@scanmail-software.com or visit our web site.

How to do disk cleanup in Windows 7

1. Open Disk Cleanup by clicking the Start button Picture of the Start button, clicking All Programs, clicking Accessories, clicking System Tools, and then clicking Disk Cleanup.
2. In the Disk Cleanup Options dialog box, choose whether you want to clean up your own files only or all of the files on the computer. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
3. If the Disk Cleanup: Drive Selection dialog box appears, select the hard disk drive that you want to clean up, and then click OK.
4. Click the Disk Cleanup tab, and then select the check boxes for the files you want to delete.
5. When you finish selecting the files you want to delete, click OK, and then click Delete files to confirm the operation. Disk Cleanup proceeds to remove all unnecessary files from your computer.

For more information or technical support by phone for Windows 7 call us at 410-838-5100