Howtos / Articles

Remove anonymous user from MySQL

MySQL includes an anonymous user account that allows anyone to connect into the MySQL server without having a user account. This is meant only for testing, and should be removed before the database server is put into a production environment. Run the following SQL script against the MySQL server to remove the anonymous user account: DELETE FROM mysql.user WHERE User=”; After making changes to permissions/user accounts, make sure you flush the provilege tables using the following command: FLUSH PRIVILEGES;…

Read more [...]

Secure a MySQL installation using mysql_secure_installation

A standard installation of MySQL includes a number of tools to manage the database server. One of these tools is the ‘mysql_secure_installation’ script. This script guides the user through setting up a secure MySQL root password, removes the anonymous user account, disabling remote root connections, removes the test database, and finally flushes all the changed made to make sure they are active. To execute the script, simply run the following command: $ mysql_secure_installation In summary, these are the questions that…

Read more [...]

Start a Headless VirtualBox Virtual Machine on Windows

Oracle’s VirtualBox software comes with a wide range of command line tools that allow you to manage the VirtualBox virtual machines. One of these tools is “VBoxHeadless.exe”. This tool allows you to start up a virtual machine from the command line, without having to load the Virtualbox application itself. This is great for when the virtual machine you want to run is a server, and you want to only connect into it using SSH or RDP, instead of using the…

Read more [...]

PowerShell Command to Show Exchange Service Status

The “Get-Service” PowerShell command can be used to display the status of all services on a machine. To make this easier to read, and to narrow down the results to specific services, you can pipe the output to “Where” and filter the results. The following command displays a list of Microsoft Exchange related services, and their statuses. Get-Service | Where {$_.DisplayName -Like "*Exchange*"} | ft DisplayName, Name, Status Example output: This command can be modified easily to filter for another…

Read more [...]

View Exchange Mailbox statistics from the PowerShell

The “Get-MailboxStatistics” PowerShell command can be used to view statistics for a specified mailbox/user account. The only required parameter is the mailbox name, or the user identity. For example: Get-MailboxStatistics -Identity Administrator” Simply running the Get-MailboxStatistics as per the example above, you will only see a few of the columns that get returned (DisplayName, ItemCount, StorageLimitStatus, and LastLogonTime). To view all the available columns/values, you can pipe the Get-MailboxStatistics command to “fl”, which outputs the data in a Formatted List…

Read more [...]



Page 25 of 39« First...10...21222324252627282930...Last »